import pandas as pd
df = pd.read_csv("mental.csv")
df
| Country | Year | males | females | |
|---|---|---|---|---|
| 0 | Afghanistan | 2017 | 16.674168 | 16.963023 |
| 1 | Albania | 2017 | 10.646518 | 11.043173 |
| 2 | Algeria | 2017 | 14.063803 | 15.011597 |
| 3 | American Samoa | 2017 | 10.687930 | 11.004269 |
| 4 | Andean Latin America | 2017 | 11.973561 | 12.787111 |
| 5 | Andorra | 2017 | 13.610023 | 15.861840 |
| 6 | Angola | 2017 | 12.436696 | 12.322946 |
| 7 | Antigua and Barbuda | 2017 | 13.008220 | 13.392391 |
| 8 | Argentina | 2017 | 13.698439 | 17.598748 |
| 9 | Armenia | 2017 | 10.679067 | 10.574900 |
| 10 | Australasia | 2017 | 17.426564 | 19.354329 |
| 11 | Australia | 2017 | 17.468624 | 19.216194 |
| 12 | Austria | 2017 | 13.064812 | 15.600716 |
| 13 | Azerbaijan | 2017 | 10.361989 | 10.416485 |
| 14 | Bahamas | 2017 | 13.153293 | 13.491201 |
| 15 | Bahrain | 2017 | 13.914962 | 14.816274 |
| 16 | Bangladesh | 2017 | 11.611247 | 13.289032 |
| 17 | Barbados | 2017 | 13.461973 | 13.602635 |
| 18 | Belarus | 2017 | 11.972856 | 12.081957 |
| 19 | Belgium | 2017 | 14.329592 | 15.653381 |
| 20 | Belize | 2017 | 13.388840 | 13.472870 |
| 21 | Benin | 2017 | 11.889258 | 11.693028 |
| 22 | Bermuda | 2017 | 13.511998 | 13.902880 |
| 23 | Bhutan | 2017 | 11.614106 | 12.241409 |
| 24 | Bolivia | 2017 | 12.167645 | 13.311968 |
| 25 | Bosnia and Herzegovina | 2017 | 10.809952 | 11.091413 |
| 26 | Botswana | 2017 | 12.967178 | 12.127932 |
| 27 | Brazil | 2017 | 13.092926 | 15.792622 |
| 28 | Brunei | 2017 | 11.163510 | 11.743905 |
| 29 | Bulgaria | 2017 | 11.055337 | 11.374022 |
| ... | ... | ... | ... | ... |
| 201 | Taiwan | 2017 | 11.624662 | 11.338834 |
| 202 | Tajikistan | 2017 | 10.649450 | 10.659094 |
| 203 | Tanzania | 2017 | 11.855598 | 12.857774 |
| 204 | Thailand | 2017 | 11.918767 | 11.578325 |
| 205 | Timor | 2017 | 11.094804 | 12.164470 |
| 206 | Togo | 2017 | 11.846319 | 11.644117 |
| 207 | Tonga | 2017 | 10.756314 | 11.120704 |
| 208 | Trinidad and Tobago | 2017 | 13.899191 | 14.133760 |
| 209 | Tropical Latin America | 2017 | 13.087586 | 15.780627 |
| 210 | Tunisia | 2017 | 15.052460 | 15.465274 |
| 211 | Turkey | 2017 | 14.196733 | 14.355624 |
| 212 | Turkmenistan | 2017 | 10.608665 | 10.613201 |
| 213 | Uganda | 2017 | 12.976859 | 13.790202 |
| 214 | Ukraine | 2017 | 12.075127 | 11.993509 |
| 215 | United Arab Emirates | 2017 | 12.324823 | 12.977993 |
| 216 | United Kingdom | 2017 | 14.033962 | 15.216455 |
| 217 | United States | 2017 | 16.263874 | 18.347446 |
| 218 | United States Virgin Islands | 2017 | 13.632595 | 13.892177 |
| 219 | Uruguay | 2017 | 13.775042 | 17.557468 |
| 220 | Uzbekistan | 2017 | 10.731370 | 10.625033 |
| 221 | Vanuatu | 2017 | 11.085659 | 11.318353 |
| 222 | Venezuela | 2017 | 11.181886 | 11.003374 |
| 223 | Vietnam | 2017 | 8.988939 | 10.346828 |
| 224 | Wales | 2017 | 13.805811 | 15.248820 |
| 225 | Western Europe | 2017 | 13.861182 | 16.669722 |
| 226 | Western Sub-Saharan Africa | 2017 | 11.801576 | 11.802223 |
| 227 | World | 2017 | 12.581199 | 13.245729 |
| 228 | Yemen | 2017 | 15.514807 | 16.296067 |
| 229 | Zambia | 2017 | 12.047292 | 12.528861 |
| 230 | Zimbabwe | 2017 | 12.561063 | 10.740696 |
231 rows × 4 columns
df.Country
0 Afghanistan
1 Albania
2 Algeria
3 American Samoa
4 Andean Latin America
5 Andorra
6 Angola
7 Antigua and Barbuda
8 Argentina
9 Armenia
10 Australasia
11 Australia
12 Austria
13 Azerbaijan
14 Bahamas
15 Bahrain
16 Bangladesh
17 Barbados
18 Belarus
19 Belgium
20 Belize
21 Benin
22 Bermuda
23 Bhutan
24 Bolivia
25 Bosnia and Herzegovina
26 Botswana
27 Brazil
28 Brunei
29 Bulgaria
...
201 Taiwan
202 Tajikistan
203 Tanzania
204 Thailand
205 Timor
206 Togo
207 Tonga
208 Trinidad and Tobago
209 Tropical Latin America
210 Tunisia
211 Turkey
212 Turkmenistan
213 Uganda
214 Ukraine
215 United Arab Emirates
216 United Kingdom
217 United States
218 United States Virgin Islands
219 Uruguay
220 Uzbekistan
221 Vanuatu
222 Venezuela
223 Vietnam
224 Wales
225 Western Europe
226 Western Sub-Saharan Africa
227 World
228 Yemen
229 Zambia
230 Zimbabwe
Name: Country, Length: 231, dtype: object
df.females
0 16.963023
1 11.043173
2 15.011597
3 11.004269
4 12.787111
5 15.861840
6 12.322946
7 13.392391
8 17.598748
9 10.574900
10 19.354329
11 19.216194
12 15.600716
13 10.416485
14 13.491201
15 14.816274
16 13.289032
17 13.602635
18 12.081957
19 15.653381
20 13.472870
21 11.693028
22 13.902880
23 12.241409
24 13.311968
25 11.091413
26 12.127932
27 15.792622
28 11.743905
29 11.374022
...
201 11.338834
202 10.659094
203 12.857774
204 11.578325
205 12.164470
206 11.644117
207 11.120704
208 14.133760
209 15.780627
210 15.465274
211 14.355624
212 10.613201
213 13.790202
214 11.993509
215 12.977993
216 15.216455
217 18.347446
218 13.892177
219 17.557468
220 10.625033
221 11.318353
222 11.003374
223 10.346828
224 15.248820
225 16.669722
226 11.802223
227 13.245729
228 16.296067
229 12.528861
230 10.740696
Name: females, Length: 231, dtype: float64
df.males
0 16.674168
1 10.646518
2 14.063803
3 10.687930
4 11.973561
5 13.610023
6 12.436696
7 13.008220
8 13.698439
9 10.679067
10 17.426564
11 17.468624
12 13.064812
13 10.361989
14 13.153293
15 13.914962
16 11.611247
17 13.461973
18 11.972856
19 14.329592
20 13.388840
21 11.889258
22 13.511998
23 11.614106
24 12.167645
25 10.809952
26 12.967178
27 13.092926
28 11.163510
29 11.055337
...
201 11.624662
202 10.649450
203 11.855598
204 11.918767
205 11.094804
206 11.846319
207 10.756314
208 13.899191
209 13.087586
210 15.052460
211 14.196733
212 10.608665
213 12.976859
214 12.075127
215 12.324823
216 14.033962
217 16.263874
218 13.632595
219 13.775042
220 10.731370
221 11.085659
222 11.181886
223 8.988939
224 13.805811
225 13.861182
226 11.801576
227 12.581199
228 15.514807
229 12.047292
230 12.561063
Name: males, Length: 231, dtype: float64
各国男性心理健康障碍患病率 = list(zip(list(df.Country),list(df.males)))
print(各国男性心理健康障碍患病率)
[('Afghanistan', 16.67416817), ('Albania', 10.64651811), ('Algeria', 14.06380308), ('American Samoa', 10.68793033), ('Andean Latin America', 11.97356068), ('Andorra', 13.61002276), ('Angola', 12.43669585), ('Antigua and Barbuda', 13.00821952), ('Argentina', 13.69843913), ('Armenia', 10.67906688), ('Australasia', 17.42656401), ('Australia', 17.46862358), ('Austria', 13.06481225), ('Azerbaijan', 10.36198933), ('Bahamas', 13.15329281), ('Bahrain', 13.91496228), ('Bangladesh', 11.61124711), ('Barbados', 13.46197286), ('Belarus', 11.97285592), ('Belgium', 14.32959246), ('Belize', 13.38883967), ('Benin', 11.88925815), ('Bermuda', 13.51199818), ('Bhutan', 11.614105699999998), ('Bolivia', 12.16764512), ('Bosnia and Herzegovina', 10.8099522), ('Botswana', 12.967178), ('Brazil', 13.09292581), ('Brunei', 11.16350955), ('Bulgaria', 11.05533664), ('Burkina Faso', 11.99977992), ('Burundi', 12.52197071), ('Cambodia', 11.00569858), ('Cameroon', 11.86670138), ('Canada', 15.28562543), ('Cape Verde', 12.75501296), ('Caribbean', 13.47520411), ('Central African Republic', 12.85362372), ('Central Asia', 10.8029663), ('Central Europe', 11.02671844), ('Central Europe, Eastern Europe, and Central Asia', 11.31505007), ('Central Latin America', 10.56520024), ('Central Sub-Saharan Africa', 12.56184524), ('Chad', 12.04486783), ('Chile', 13.967695), ('China', 11.35249761), ('Colombia', 10.43344509), ('Comoros', 11.85924207), ('Congo', 12.31508087), ('Costa Rica', 11.00603676), ("Cote d'Ivoire", 11.64569968), ('Croatia', 11.36712535), ('Cuba', 13.97620114), ('Cyprus', 13.09818835), ('Czech Republic', 11.27347261), ('Democratic Republic of Congo', 12.60708532), ('Denmark', 13.28569218), ('Djibouti', 12.24017226), ('Dominica', 13.19952446), ('Dominican Republic', 13.29665253), ('East Asia', 11.36693767), ('Eastern Europe', 11.73492916), ('Eastern Sub-Saharan Africa', 12.27593371), ('Ecuador', 12.38856483), ('Egypt', 14.29446933), ('El Salvador', 10.78907826), ('England', 14.03463551), ('Equatorial Guinea', 12.43594893), ('Eritrea', 12.37119592), ('Estonia', 11.80539473), ('Ethiopia', 12.53710899), ('Fiji', 10.95245987), ('Finland', 14.58086006), ('France', 14.25309767), ('Gabon', 12.506091), ('Gambia', 11.60140376), ('Georgia', 10.76457749), ('Germany', 13.17717679), ('Ghana', 11.73997671), ('Greece', 14.0109792), ('Greenland', 16.66093702), ('Grenada', 13.39275462), ('Guam', 11.36081544), ('Guatemala', 10.87408272), ('Guinea', 11.62885985), ('Guinea-Bissau', 11.65543595), ('Guyana', 14.17509458), ('Haiti', 13.20468727), ('High SDI', 14.08900942), ('High-income', 14.45598174), ('High-income Asia Pacific', 12.05491117), ('High-middle SDI', 12.29541915), ('Honduras', 10.52434945), ('Hungary', 11.197610800000001), ('Iceland', 13.08986919), ('India', 14.45885164), ('Indonesia', 10.15248794), ('Iran', 17.05942369), ('Iraq', 12.53082199), ('Ireland', 14.41110801), ('Israel', 12.31986302), ('Italy', 13.657126199999999), ('Jamaica', 13.12333348), ('Japan', 12.56811524), ('Jordan', 13.9798924), ('Kazakhstan', 11.20393598), ('Kenya', 11.93529175), ('Kiribati', 11.2850625), ('Kuwait', 13.65292554), ('Kyrgyzstan', 10.997480099999999), ('Laos', 11.61248718), ('Latin America and Caribbean', 11.91924202), ('Latvia', 11.64982837), ('Lebanon', 15.09501885), ('Lesotho', 14.14159748), ('Liberia', 11.42404899), ('Libya', 14.17841664), ('Lithuania', 12.0622496), ('Low SDI', 13.44856223), ('Low-middle SDI', 13.02148124), ('Luxembourg', 13.40541934), ('Macedonia', 10.80843731), ('Madagascar', 12.19106951), ('Malawi', 11.922353999999999), ('Malaysia', 11.45581441), ('Maldives', 10.65300923), ('Mali', 11.31907313), ('Malta', 13.25747182), ('Marshall Islands', 11.03854769), ('Mauritania', 11.62124395), ('Mauritius', 10.82834539), ('Mexico', 10.39246595), ('Micronesia (country)', 11.08075622), ('Middle SDI', 11.61658385), ('Moldova', 11.52270092), ('Mongolia', 11.25406267), ('Montenegro', 10.99517127), ('Morocco', 15.47840828), ('Mozambique', 12.32834321), ('Myanmar', 10.17073899), ('Namibia', 12.73008843), ('Nepal', 12.52838711), ('Netherlands', 14.63224271), ('New Zealand', 17.18089865), ('Nicaragua', 10.88790481), ('Niger', 12.09100472), ('Nigeria', 11.83557218), ('North Africa and Middle East', 14.7801783), ('North America', 16.16828833), ('North Korea', 11.91595804), ('Northern Ireland', 15.97895436), ('Northern Mariana Islands', 11.068200099999999), ('Norway', 14.80513401), ('Oceania', 11.13128848), ('Oman', 13.46183451), ('Pakistan', 11.52209368), ('Palestine', 15.70642814), ('Panama', 10.70246104), ('Papua New Guinea', 11.15925308), ('Paraguay', 12.95005176), ('Peru', 11.71555393), ('Philippines', 10.39104478), ('Poland', 11.06641284), ('Portugal', 13.91262674), ('Puerto Rico', 13.61382087), ('Qatar', 13.59611741), ('Romania', 10.77483797), ('Russia', 11.61144037), ('Rwanda', 12.04162058), ('Saint Lucia', 13.48582736), ('Saint Vincent and the Grenadines', 13.474190599999998), ('Samoa', 10.85143129), ('Sao Tome and Principe', 11.41433574), ('Saudi Arabia', 13.25645543), ('Scotland', 13.44656424), ('Senegal', 11.69102167), ('Serbia', 11.01673013), ('Seychelles', 10.52810266), ('Sierra Leone', 11.68906926), ('Singapore', 12.0350557), ('Slovakia', 10.89585216), ('Slovenia', 11.33071529), ('Solomon Islands', 11.229545199999999), ('Somalia', 12.5931244), ('South Africa', 12.75893546), ('South Asia', 13.83438991), ('South Korea', 11.06356522), ('South Sudan', 11.85204781), ('Southeast Asia', 10.33147405), ('Southeast Asia, East Asia, and Oceania', 11.00054655), ('Southern Latin America', 13.77690148), ('Southern Sub-Saharan Africa', 12.76207642), ('Spain', 14.45882611), ('Sri Lanka', 11.15209358), ('Sub-Saharan Africa', 12.14966965), ('Sudan', 15.92035535), ('Suriname', 14.03425226), ('Swaziland', 13.06597094), ('Sweden', 14.04922185), ('Switzerland', 13.5581555), ('Syria', 14.45703852), ('Taiwan', 11.62466188), ('Tajikistan', 10.64944954), ('Tanzania', 11.85559758), ('Thailand', 11.91876723), ('Timor', 11.09480421), ('Togo', 11.84631867), ('Tonga', 10.75631418), ('Trinidad and Tobago', 13.89919098), ('Tropical Latin America', 13.087585800000001), ('Tunisia', 15.05246048), ('Turkey', 14.19673292), ('Turkmenistan', 10.60866465), ('Uganda', 12.97685878), ('Ukraine', 12.07512714), ('United Arab Emirates', 12.32482273), ('United Kingdom', 14.033961699999999), ('United States', 16.26387429), ('United States Virgin Islands', 13.63259525), ('Uruguay', 13.77504167), ('Uzbekistan', 10.73137001), ('Vanuatu', 11.08565901), ('Venezuela', 11.18188559), ('Vietnam', 8.988939185), ('Wales', 13.80581111), ('Western Europe', 13.86118205), ('Western Sub-Saharan Africa', 11.80157631), ('World', 12.58119894), ('Yemen', 15.51480665), ('Zambia', 12.04729227), ('Zimbabwe', 12.56106349)]
a=list(df.Country.values)
a
['Afghanistan', 'Albania', 'Algeria', 'American Samoa', 'Andean Latin America', 'Andorra', 'Angola', 'Antigua and Barbuda', 'Argentina', 'Armenia', 'Australasia', 'Australia', 'Austria', 'Azerbaijan', 'Bahamas', 'Bahrain', 'Bangladesh', 'Barbados', 'Belarus', 'Belgium', 'Belize', 'Benin', 'Bermuda', 'Bhutan', 'Bolivia', 'Bosnia and Herzegovina', 'Botswana', 'Brazil', 'Brunei', 'Bulgaria', 'Burkina Faso', 'Burundi', 'Cambodia', 'Cameroon', 'Canada', 'Cape Verde', 'Caribbean', 'Central African Republic', 'Central Asia', 'Central Europe', 'Central Europe, Eastern Europe, and Central Asia', 'Central Latin America', 'Central Sub-Saharan Africa', 'Chad', 'Chile', 'China', 'Colombia', 'Comoros', 'Congo', 'Costa Rica', "Cote d'Ivoire", 'Croatia', 'Cuba', 'Cyprus', 'Czech Republic', 'Democratic Republic of Congo', 'Denmark', 'Djibouti', 'Dominica', 'Dominican Republic', 'East Asia', 'Eastern Europe', 'Eastern Sub-Saharan Africa', 'Ecuador', 'Egypt', 'El Salvador', 'England', 'Equatorial Guinea', 'Eritrea', 'Estonia', 'Ethiopia', 'Fiji', 'Finland', 'France', 'Gabon', 'Gambia', 'Georgia', 'Germany', 'Ghana', 'Greece', 'Greenland', 'Grenada', 'Guam', 'Guatemala', 'Guinea', 'Guinea-Bissau', 'Guyana', 'Haiti', 'High SDI', 'High-income', 'High-income Asia Pacific', 'High-middle SDI', 'Honduras', 'Hungary', 'Iceland', 'India', 'Indonesia', 'Iran', 'Iraq', 'Ireland', 'Israel', 'Italy', 'Jamaica', 'Japan', 'Jordan', 'Kazakhstan', 'Kenya', 'Kiribati', 'Kuwait', 'Kyrgyzstan', 'Laos', 'Latin America and Caribbean', 'Latvia', 'Lebanon', 'Lesotho', 'Liberia', 'Libya', 'Lithuania', 'Low SDI', 'Low-middle SDI', 'Luxembourg', 'Macedonia', 'Madagascar', 'Malawi', 'Malaysia', 'Maldives', 'Mali', 'Malta', 'Marshall Islands', 'Mauritania', 'Mauritius', 'Mexico', 'Micronesia (country)', 'Middle SDI', 'Moldova', 'Mongolia', 'Montenegro', 'Morocco', 'Mozambique', 'Myanmar', 'Namibia', 'Nepal', 'Netherlands', 'New Zealand', 'Nicaragua', 'Niger', 'Nigeria', 'North Africa and Middle East', 'North America', 'North Korea', 'Northern Ireland', 'Northern Mariana Islands', 'Norway', 'Oceania', 'Oman', 'Pakistan', 'Palestine', 'Panama', 'Papua New Guinea', 'Paraguay', 'Peru', 'Philippines', 'Poland', 'Portugal', 'Puerto Rico', 'Qatar', 'Romania', 'Russia', 'Rwanda', 'Saint Lucia', 'Saint Vincent and the Grenadines', 'Samoa', 'Sao Tome and Principe', 'Saudi Arabia', 'Scotland', 'Senegal', 'Serbia', 'Seychelles', 'Sierra Leone', 'Singapore', 'Slovakia', 'Slovenia', 'Solomon Islands', 'Somalia', 'South Africa', 'South Asia', 'South Korea', 'South Sudan', 'Southeast Asia', 'Southeast Asia, East Asia, and Oceania', 'Southern Latin America', 'Southern Sub-Saharan Africa', 'Spain', 'Sri Lanka', 'Sub-Saharan Africa', 'Sudan', 'Suriname', 'Swaziland', 'Sweden', 'Switzerland', 'Syria', 'Taiwan', 'Tajikistan', 'Tanzania', 'Thailand', 'Timor', 'Togo', 'Tonga', 'Trinidad and Tobago', 'Tropical Latin America', 'Tunisia', 'Turkey', 'Turkmenistan', 'Uganda', 'Ukraine', 'United Arab Emirates', 'United Kingdom', 'United States', 'United States Virgin Islands', 'Uruguay', 'Uzbekistan', 'Vanuatu', 'Venezuela', 'Vietnam', 'Wales', 'Western Europe', 'Western Sub-Saharan Africa', 'World', 'Yemen', 'Zambia', 'Zimbabwe']
d=list(df.males.values)
d
[16.67416817, 10.64651811, 14.06380308, 10.68793033, 11.97356068, 13.61002276, 12.43669585, 13.00821952, 13.69843913, 10.67906688, 17.42656401, 17.46862358, 13.06481225, 10.36198933, 13.15329281, 13.91496228, 11.61124711, 13.46197286, 11.97285592, 14.32959246, 13.38883967, 11.88925815, 13.51199818, 11.614105699999998, 12.16764512, 10.8099522, 12.967178, 13.09292581, 11.16350955, 11.05533664, 11.99977992, 12.52197071, 11.00569858, 11.86670138, 15.28562543, 12.75501296, 13.47520411, 12.85362372, 10.8029663, 11.02671844, 11.31505007, 10.56520024, 12.56184524, 12.04486783, 13.967695, 11.35249761, 10.43344509, 11.85924207, 12.31508087, 11.00603676, 11.64569968, 11.36712535, 13.97620114, 13.09818835, 11.27347261, 12.60708532, 13.28569218, 12.24017226, 13.19952446, 13.29665253, 11.36693767, 11.73492916, 12.27593371, 12.38856483, 14.29446933, 10.78907826, 14.03463551, 12.43594893, 12.37119592, 11.80539473, 12.53710899, 10.95245987, 14.58086006, 14.25309767, 12.506091, 11.60140376, 10.76457749, 13.17717679, 11.73997671, 14.0109792, 16.66093702, 13.39275462, 11.36081544, 10.87408272, 11.62885985, 11.65543595, 14.17509458, 13.20468727, 14.08900942, 14.45598174, 12.05491117, 12.29541915, 10.52434945, 11.197610800000001, 13.08986919, 14.45885164, 10.15248794, 17.05942369, 12.53082199, 14.41110801, 12.31986302, 13.657126199999999, 13.12333348, 12.56811524, 13.9798924, 11.20393598, 11.93529175, 11.2850625, 13.65292554, 10.997480099999999, 11.61248718, 11.91924202, 11.64982837, 15.09501885, 14.14159748, 11.42404899, 14.17841664, 12.0622496, 13.44856223, 13.02148124, 13.40541934, 10.80843731, 12.19106951, 11.922353999999999, 11.45581441, 10.65300923, 11.31907313, 13.25747182, 11.03854769, 11.62124395, 10.82834539, 10.39246595, 11.08075622, 11.61658385, 11.52270092, 11.25406267, 10.99517127, 15.47840828, 12.32834321, 10.17073899, 12.73008843, 12.52838711, 14.63224271, 17.18089865, 10.88790481, 12.09100472, 11.83557218, 14.7801783, 16.16828833, 11.91595804, 15.97895436, 11.068200099999999, 14.80513401, 11.13128848, 13.46183451, 11.52209368, 15.70642814, 10.70246104, 11.15925308, 12.95005176, 11.71555393, 10.39104478, 11.06641284, 13.91262674, 13.61382087, 13.59611741, 10.77483797, 11.61144037, 12.04162058, 13.48582736, 13.474190599999998, 10.85143129, 11.41433574, 13.25645543, 13.44656424, 11.69102167, 11.01673013, 10.52810266, 11.68906926, 12.0350557, 10.89585216, 11.33071529, 11.229545199999999, 12.5931244, 12.75893546, 13.83438991, 11.06356522, 11.85204781, 10.33147405, 11.00054655, 13.77690148, 12.76207642, 14.45882611, 11.15209358, 12.14966965, 15.92035535, 14.03425226, 13.06597094, 14.04922185, 13.5581555, 14.45703852, 11.62466188, 10.64944954, 11.85559758, 11.91876723, 11.09480421, 11.84631867, 10.75631418, 13.89919098, 13.087585800000001, 15.05246048, 14.19673292, 10.60866465, 12.97685878, 12.07512714, 12.32482273, 14.033961699999999, 16.26387429, 13.63259525, 13.77504167, 10.73137001, 11.08565901, 11.18188559, 8.988939185, 13.80581111, 13.86118205, 11.80157631, 12.58119894, 15.51480665, 12.04729227, 12.56106349]
from pyecharts.faker import Faker
from pyecharts import options as opts
from pyecharts.charts import Scatter
def scatter_visualmap_color() -> Scatter:
c = (
Scatter()
.add_xaxis(a)
.add_yaxis("各国男性患病率",d)
.set_global_opts(
title_opts=opts.TitleOpts(title="各国男性患病率"),
visualmap_opts=opts.VisualMapOpts(min_=10,max_=20),
)
)
return c
男性患病率= scatter_visualmap_color()
男性患病率.render_notebook()
b=list(df.females.values)
b
[16.96302255, 11.04317255, 15.01159706, 11.00426893, 12.78711135, 15.86184049, 12.32294585, 13.39239094, 17.59874775, 10.57489953, 19.35432947, 19.21619405, 15.60071603, 10.41648516, 13.49120068, 14.81627383, 13.28903163, 13.6026348, 12.08195744, 15.65338106, 13.47286976, 11.693028199999999, 13.90287959, 12.24140941, 13.31196751, 11.09141289, 12.12793237, 15.79262155, 11.74390488, 11.37402183, 11.69866487, 13.31775657, 11.86483359, 11.75166617, 15.67775188, 11.94527944, 13.83525884, 12.52543399, 10.74032131, 11.07793467, 11.35330022, 10.87214112, 12.334849499999999, 12.13279508, 18.03206451, 11.349312699999999, 9.632960357, 12.69160245, 12.24803579, 11.063826400000002, 11.36639947, 11.47753656, 14.17651035, 15.31440481, 11.35739402, 12.338106100000001, 15.22011944, 12.93323532, 13.36071525, 13.77695698, 11.35417594, 11.77542009, 13.03665488, 13.17278014, 14.85395534, 11.16447313, 15.11067396, 12.39682448, 13.15261887, 12.09143264, 13.13708633, 11.26542022, 15.17243141, 18.31508867, 12.11815789, 12.89069875, 10.62417976, 17.10398727, 11.26053647, 16.94804923, 18.84740954, 13.39492198, 11.38931274, 11.38034381, 11.66951167, 11.74603891, 14.81224657, 13.66708124, 15.76582463, 16.58878473, 12.26919107, 12.92406777, 10.84039681, 11.49333065, 15.32941138, 14.57455363, 11.0848362, 18.37477299, 14.88806445, 16.71311162, 13.06232688, 16.03737831, 13.37008289, 12.12948742, 14.80317577, 11.12340044, 12.65522997, 11.34281384, 14.84669463, 10.90026083, 12.38845661, 13.20807069, 11.46447251, 16.69713438, 13.88127814, 12.71138902, 15.01543172, 12.15796108, 13.71076578, 13.51480553, 15.83891198, 11.14472764, 12.955444199999999, 12.62239116, 12.86586099, 11.6660741, 11.13135319, 15.44068507, 11.26795078, 11.02407465, 11.77589263, 11.27734572, 11.27620695, 12.05362494, 11.47204216, 11.10974161, 11.36457134, 16.83955197, 13.03402798, 10.75678611, 11.47981766, 13.00299634, 17.39198137, 20.07796042, 11.00770166, 11.98280649, 12.03532903, 15.76453694, 18.0854826, 11.63719877, 18.45449437, 11.00313247, 17.44120257, 11.42883974, 14.48148729, 12.428950500000001, 16.09246773, 10.84318046, 11.46752376, 15.41172376, 12.42968215, 11.21610424, 10.82358254, 16.54852173, 13.50608769, 14.70538057, 10.80038069, 11.68737421, 13.206261600000001, 13.51260182, 13.38006202, 11.08998763, 11.2637118, 14.32870148, 15.09166848, 11.24629095, 11.30709206, 11.073687300000001, 11.79165668, 12.81709577, 11.1766752, 11.73401618, 11.50176167, 13.43980578, 12.69554577, 14.14478189, 12.55000474, 12.86651345, 11.16085472, 11.3252282, 17.71580083, 12.31743926, 17.80454817, 11.74478956, 12.3589356, 16.21379206, 14.68237175, 12.000217999999998, 17.05990517, 16.11898788, 15.1725894, 11.3388338, 10.65909441, 12.85777367, 11.57832474, 12.16446983, 11.64411736, 11.12070429, 14.13376015, 15.78062659, 15.46527405, 14.35562438, 10.6132007, 13.79020212, 11.99350866, 12.97799316, 15.21645503, 18.34744604, 13.89217659, 17.55746782, 10.62503286, 11.31835322, 11.00337382, 10.34682823, 15.24882039, 16.66972185, 11.80222319, 13.24572917, 16.29606734, 12.52886108, 10.74069569]
def scatter_visualmap_color() -> Scatter:
c = (
Scatter()
.add_xaxis(a)
.add_yaxis("各国女性患病率",b)
.set_global_opts(
title_opts=opts.TitleOpts(title="各国女性患病率"),
visualmap_opts=opts.VisualMapOpts(min_=10,max_=20),
)
)
return c
女性患病率= scatter_visualmap_color()
女性患病率.render_notebook()
df = pd.read_csv('country_males.csv',encoding='gbk')
df
| Country | 2014年 | 2015年 | 2016年 | 2017年 | |
|---|---|---|---|---|---|
| 0 | Afghanistan | 16.753068 | 16.753068 | 16.710216 | 16.674168 |
| 1 | Albania | 10.648345 | 10.648345 | 10.646706 | 10.646518 |
| 2 | Algeria | 14.040733 | 14.040733 | 14.052904 | 14.063803 |
| 3 | American Samoa | 10.692175 | 10.692175 | 10.690777 | 10.687930 |
| 4 | Andean Latin America | 11.960583 | 11.960583 | 11.966371 | 11.973561 |
| 5 | Andorra | 13.604457 | 13.604457 | 13.606560 | 13.610023 |
| 6 | Angola | 12.432163 | 12.432163 | 12.426484 | 12.436696 |
| 7 | Antigua and Barbuda | 12.985714 | 12.985714 | 12.997266 | 13.008220 |
| 8 | Argentina | 13.693613 | 13.693613 | 13.694336 | 13.698439 |
| 9 | Armenia | 10.668466 | 10.668466 | 10.673325 | 10.679067 |
| 10 | Australasia | 17.482444 | 17.482444 | 17.455354 | 17.426564 |
| 11 | Australia | 17.541716 | 17.541716 | 17.506214 | 17.468624 |
| 12 | Austria | 13.056921 | 13.056921 | 13.061996 | 13.064812 |
| 13 | Azerbaijan | 10.346065 | 10.346065 | 10.352749 | 10.361989 |
| 14 | Bahamas | 13.139873 | 13.139873 | 13.146737 | 13.153293 |
| 15 | Bahrain | 13.935663 | 13.935663 | 13.926110 | 13.914962 |
| 16 | Bangladesh | 11.683577 | 11.683577 | 11.647271 | 11.611247 |
| 17 | Barbados | 13.450219 | 13.450219 | 13.455483 | 13.461973 |
| 18 | Belarus | 11.990550 | 11.990550 | 11.980922 | 11.972856 |
| 19 | Belgium | 14.316352 | 14.316352 | 14.320781 | 14.329592 |
| 20 | Belize | 13.380601 | 13.380601 | 13.384853 | 13.388840 |
| 21 | Benin | 11.894483 | 11.894483 | 11.890957 | 11.889258 |
| 22 | Bermuda | 13.511195 | 13.511195 | 13.513414 | 13.511998 |
| 23 | Bhutan | 11.611875 | 11.611875 | 11.612839 | 11.614106 |
| 24 | Bolivia | 12.151095 | 12.151095 | 12.159193 | 12.167645 |
| 25 | Bosnia and Herzegovina | 10.814691 | 10.814691 | 10.807901 | 10.809952 |
| 26 | Botswana | 12.962635 | 12.962635 | 12.960634 | 12.967178 |
| 27 | Brazil | 13.137667 | 13.137667 | 13.112796 | 13.092926 |
| 28 | Brunei | 11.146618 | 11.146618 | 11.156479 | 11.163510 |
| 29 | Bulgaria | 11.049463 | 11.049463 | 11.050733 | 11.055337 |
| ... | ... | ... | ... | ... | ... |
| 201 | Taiwan | 11.640860 | 11.640860 | 11.633695 | 11.624662 |
| 202 | Tajikistan | 10.677559 | 10.677559 | 10.664176 | 10.649450 |
| 203 | Tanzania | 11.830207 | 11.830207 | 11.840556 | 11.855598 |
| 204 | Thailand | 11.985698 | 11.985698 | 11.950009 | 11.918767 |
| 205 | Timor | 11.166420 | 11.166420 | 11.129563 | 11.094804 |
| 206 | Togo | 11.843465 | 11.843465 | 11.845105 | 11.846319 |
| 207 | Tonga | 10.763040 | 10.763040 | 10.757886 | 10.756314 |
| 208 | Trinidad and Tobago | 13.899670 | 13.899670 | 13.896499 | 13.899191 |
| 209 | Tropical Latin America | 13.131173 | 13.131173 | 13.106959 | 13.087586 |
| 210 | Tunisia | 15.063216 | 15.063216 | 15.057527 | 15.052460 |
| 211 | Turkey | 14.232132 | 14.232132 | 14.216167 | 14.196733 |
| 212 | Turkmenistan | 10.598564 | 10.598564 | 10.604102 | 10.608665 |
| 213 | Uganda | 13.008787 | 13.008787 | 12.994770 | 12.976859 |
| 214 | Ukraine | 12.079771 | 12.079771 | 12.080820 | 12.075127 |
| 215 | United Arab Emirates | 12.306707 | 12.306707 | 12.319466 | 12.324823 |
| 216 | United Kingdom | 14.022247 | 14.022247 | 14.027517 | 14.033962 |
| 217 | United States | 16.278150 | 16.278150 | 16.270533 | 16.263874 |
| 218 | United States Virgin Islands | 13.632367 | 13.632367 | 13.632504 | 13.632595 |
| 219 | Uruguay | 13.759703 | 13.759703 | 13.762565 | 13.775042 |
| 220 | Uzbekistan | 10.752260 | 10.752260 | 10.744390 | 10.731370 |
| 221 | Vanuatu | 11.103429 | 11.103429 | 11.095058 | 11.085659 |
| 222 | Venezuela | 11.186214 | 11.186214 | 11.184497 | 11.181886 |
| 223 | Vietnam | 8.966948 | 8.966948 | 8.973221 | 8.988939 |
| 224 | Wales | 13.772225 | 13.772225 | 13.784068 | 13.805811 |
| 225 | Western Europe | 13.871859 | 13.871859 | 13.864468 | 13.861182 |
| 226 | Western Sub-Saharan Africa | 11.843181 | 11.843181 | 11.824578 | 11.801576 |
| 227 | World | 12.595280 | 12.595280 | 12.588114 | 12.581199 |
| 228 | Yemen | 15.410116 | 15.410116 | 15.458473 | 15.514807 |
| 229 | Zambia | 11.994085 | 11.994085 | 12.016855 | 12.047292 |
| 230 | Zimbabwe | 12.529954 | 12.529954 | 12.546594 | 12.561063 |
231 rows × 5 columns
for i in range(2014,2018):
print(list(zip(list(df.Country),list(df["{}年".format(i)]))))
[('Afghanistan', 16.75306774), ('Albania', 10.64834484), ('Algeria', 14.04073325), ('American Samoa', 10.69217484), ('Andean Latin America', 11.96058294), ('Andorra', 13.60445701), ('Angola', 12.43216273), ('Antigua and Barbuda', 12.98571441), ('Argentina', 13.693613099999999), ('Armenia', 10.66846575), ('Australasia', 17.48244379), ('Australia', 17.5417157), ('Austria', 13.0569209), ('Azerbaijan', 10.34606519), ('Bahamas', 13.13987283), ('Bahrain', 13.93566286), ('Bangladesh', 11.68357749), ('Barbados', 13.4502185), ('Belarus', 11.99055015), ('Belgium', 14.31635168), ('Belize', 13.38060095), ('Benin', 11.89448323), ('Bermuda', 13.51119534), ('Bhutan', 11.61187518), ('Bolivia', 12.15109511), ('Bosnia and Herzegovina', 10.81469116), ('Botswana', 12.96263546), ('Brazil', 13.1376673), ('Brunei', 11.14661798), ('Bulgaria', 11.04946267), ('Burkina Faso', 11.99926023), ('Burundi', 12.51429148), ('Cambodia', 11.09367967), ('Cameroon', 11.86821639), ('Canada', 15.23991322), ('Cape Verde', 12.76697234), ('Caribbean', 13.47537007), ('Central African Republic', 12.84544228), ('Central Asia', 10.81437141), ('Central Europe', 11.02839755), ('Central Europe, Eastern Europe, and Central Asia', 11.32344874), ('Central Latin America', 10.543919800000001), ('Central Sub-Saharan Africa', 12.58834133), ('Chad', 12.06724311), ('Chile', 13.95745981), ('China', 11.39474934), ('Colombia', 10.40575923), ('Comoros', 11.81482608), ('Congo', 12.29624383), ('Costa Rica', 10.99572287), ("Cote d'Ivoire", 11.59835209), ('Croatia', 11.37125952), ('Cuba', 13.9771386), ('Cyprus', 13.08969953), ('Czech Republic', 11.27719677), ('Democratic Republic of Congo', 12.64870278), ('Denmark', 13.30040468), ('Djibouti', 12.22858991), ('Dominica', 13.18481996), ('Dominican Republic', 13.28666083), ('East Asia', 11.40807681), ('Eastern Europe', 11.73588221), ('Eastern Sub-Saharan Africa', 12.30278909), ('Ecuador', 12.35992247), ('Egypt', 14.25407228), ('El Salvador', 10.78078676), ('England', 14.01874982), ('Equatorial Guinea', 12.4083714), ('Eritrea', 12.38025317), ('Estonia', 11.808701300000001), ('Ethiopia', 12.60042613), ('Fiji', 10.9573569), ('Finland', 14.63350269), ('France', 14.25999645), ('Gabon', 12.5006247), ('Gambia', 11.57262031), ('Georgia', 10.75236178), ('Germany', 13.215347400000002), ('Ghana', 11.70245383), ('Greece', 14.05690627), ('Greenland', 16.69531109), ('Grenada', 13.38709916), ('Guam', 11.38634182), ('Guatemala', 10.88260856), ('Guinea', 11.62570707), ('Guinea-Bissau', 11.65574864), ('Guyana', 14.196930300000002), ('Haiti', 13.21063548), ('High SDI', 14.07771203), ('High-income', 14.44867161), ('High-income Asia Pacific', 12.0110742), ('High-middle SDI', 12.30195484), ('Honduras', 10.511519900000001), ('Hungary', 11.19613924), ('Iceland', 13.07430478), ('India', 14.48041012), ('Indonesia', 10.19548517), ('Iran', 17.10515044), ('Iraq', 12.51640219), ('Ireland', 14.41573785), ('Israel', 12.37333434), ('Italy', 13.64377137), ('Jamaica', 13.10665571), ('Japan', 12.50892752), ('Jordan', 13.96355962), ('Kazakhstan', 11.20716643), ('Kenya', 11.94361848), ('Kiribati', 11.30531562), ('Kuwait', 13.617170499999999), ('Kyrgyzstan', 11.01629241), ('Laos', 11.68110429), ('Latin America and Caribbean', 11.93323463), ('Latvia', 11.63982479), ('Lebanon', 15.11374189), ('Lesotho', 14.14745232), ('Liberia', 11.44645072), ('Libya', 14.04713759), ('Lithuania', 12.05136588), ('Low SDI', 13.500414600000001), ('Low-middle SDI', 13.06063975), ('Luxembourg', 13.40093713), ('Macedonia', 10.80468757), ('Madagascar', 12.2000426), ('Malawi', 11.86167603), ('Malaysia', 11.46853908), ('Maldives', 10.68382982), ('Mali', 11.29643857), ('Malta', 13.23622222), ('Marshall Islands', 11.07409863), ('Mauritania', 11.58699221), ('Mauritius', 10.84595366), ('Mexico', 10.36060883), ('Micronesia (country)', 11.11215038), ('Middle SDI', 11.62930786), ('Moldova', 11.53233558), ('Mongolia', 11.27413316), ('Montenegro', 10.99537376), ('Morocco', 15.60313544), ('Mozambique', 12.33140432), ('Myanmar', 10.24095966), ('Namibia', 12.66672308), ('Nepal', 12.61085829), ('Netherlands', 14.64030937), ('New Zealand', 17.15716344), ('Nicaragua', 10.88840003), ('Niger', 12.08067733), ('Nigeria', 11.93993977), ('North Africa and Middle East', 14.78606624), ('North America', 16.17717485), ('North Korea', 11.91165531), ('Northern Ireland', 16.19748175), ('Northern Mariana Islands', 11.08982971), ('Norway', 14.74915644), ('Oceania', 11.18005491), ('Oman', 13.43155902), ('Pakistan', 11.60495993), ('Palestine', 15.82958053), ('Panama', 10.6803106), ('Papua New Guinea', 11.21753766), ('Paraguay', 12.94106664), ('Peru', 11.71187624), ('Philippines', 10.42211416), ('Poland', 11.0754087), ('Portugal', 13.982741699999998), ('Puerto Rico', 13.55617167), ('Qatar', 13.60175173), ('Romania', 10.76559147), ('Russia', 11.60781216), ('Rwanda', 12.01191881), ('Saint Lucia', 13.48585676), ('Saint Vincent and the Grenadines', 13.46445628), ('Samoa', 10.87308504), ('Sao Tome and Principe', 11.40172151), ('Saudi Arabia', 13.23259688), ('Scotland', 13.41587871), ('Senegal', 11.66275244), ('Serbia', 11.02036288), ('Seychelles', 10.55688476), ('Sierra Leone', 11.69887541), ('Singapore', 12.03986959), ('Slovakia', 10.89514031), ('Slovenia', 11.34078163), ('Solomon Islands', 11.28115855), ('Somalia', 12.95510515), ('South Africa', 12.71426357), ('South Asia', 13.87509431), ('South Korea', 11.0387813), ('South Sudan', 11.83744532), ('Southeast Asia', 10.37145833), ('Southeast Asia, East Asia, and Oceania', 11.04283763), ('Southern Latin America', 13.77071268), ('Southern Sub-Saharan Africa', 12.72121549), ('Spain', 14.45260241), ('Sri Lanka', 11.20967914), ('Sub-Saharan Africa', 12.17794106), ('Sudan', 15.90137244), ('Suriname', 14.03628633), ('Swaziland', 13.02198962), ('Sweden', 14.06287004), ('Switzerland', 13.54088115), ('Syria', 14.41073809), ('Taiwan', 11.64085994), ('Tajikistan', 10.67755916), ('Tanzania', 11.83020721), ('Thailand', 11.98569818), ('Timor', 11.16641994), ('Togo', 11.84346511), ('Tonga', 10.76304025), ('Trinidad and Tobago', 13.89966963), ('Tropical Latin America', 13.13117307), ('Tunisia', 15.06321639), ('Turkey', 14.23213201), ('Turkmenistan', 10.59856428), ('Uganda', 13.00878703), ('Ukraine', 12.07977145), ('United Arab Emirates', 12.30670712), ('United Kingdom', 14.02224704), ('United States', 16.27814981), ('United States Virgin Islands', 13.63236669), ('Uruguay', 13.75970288), ('Uzbekistan', 10.75225976), ('Vanuatu', 11.10342852), ('Venezuela', 11.186214199999998), ('Vietnam', 8.966947897), ('Wales', 13.77222513), ('Western Europe', 13.87185874), ('Western Sub-Saharan Africa', 11.84318086), ('World', 12.59527957), ('Yemen', 15.410115900000001), ('Zambia', 11.99408469), ('Zimbabwe', 12.52995425)]
[('Afghanistan', 16.75306774), ('Albania', 10.64834484), ('Algeria', 14.04073325), ('American Samoa', 10.69217484), ('Andean Latin America', 11.96058294), ('Andorra', 13.60445701), ('Angola', 12.43216273), ('Antigua and Barbuda', 12.98571441), ('Argentina', 13.693613099999999), ('Armenia', 10.66846575), ('Australasia', 17.48244379), ('Australia', 17.5417157), ('Austria', 13.0569209), ('Azerbaijan', 10.34606519), ('Bahamas', 13.13987283), ('Bahrain', 13.93566286), ('Bangladesh', 11.68357749), ('Barbados', 13.4502185), ('Belarus', 11.99055015), ('Belgium', 14.31635168), ('Belize', 13.38060095), ('Benin', 11.89448323), ('Bermuda', 13.51119534), ('Bhutan', 11.61187518), ('Bolivia', 12.15109511), ('Bosnia and Herzegovina', 10.81469116), ('Botswana', 12.96263546), ('Brazil', 13.1376673), ('Brunei', 11.14661798), ('Bulgaria', 11.04946267), ('Burkina Faso', 11.99926023), ('Burundi', 12.51429148), ('Cambodia', 11.09367967), ('Cameroon', 11.86821639), ('Canada', 15.23991322), ('Cape Verde', 12.76697234), ('Caribbean', 13.47537007), ('Central African Republic', 12.84544228), ('Central Asia', 10.81437141), ('Central Europe', 11.02839755), ('Central Europe, Eastern Europe, and Central Asia', 11.32344874), ('Central Latin America', 10.543919800000001), ('Central Sub-Saharan Africa', 12.58834133), ('Chad', 12.06724311), ('Chile', 13.95745981), ('China', 11.39474934), ('Colombia', 10.40575923), ('Comoros', 11.81482608), ('Congo', 12.29624383), ('Costa Rica', 10.99572287), ("Cote d'Ivoire", 11.59835209), ('Croatia', 11.37125952), ('Cuba', 13.9771386), ('Cyprus', 13.08969953), ('Czech Republic', 11.27719677), ('Democratic Republic of Congo', 12.64870278), ('Denmark', 13.30040468), ('Djibouti', 12.22858991), ('Dominica', 13.18481996), ('Dominican Republic', 13.28666083), ('East Asia', 11.40807681), ('Eastern Europe', 11.73588221), ('Eastern Sub-Saharan Africa', 12.30278909), ('Ecuador', 12.35992247), ('Egypt', 14.25407228), ('El Salvador', 10.78078676), ('England', 14.01874982), ('Equatorial Guinea', 12.4083714), ('Eritrea', 12.38025317), ('Estonia', 11.808701300000001), ('Ethiopia', 12.60042613), ('Fiji', 10.9573569), ('Finland', 14.63350269), ('France', 14.25999645), ('Gabon', 12.5006247), ('Gambia', 11.57262031), ('Georgia', 10.75236178), ('Germany', 13.215347400000002), ('Ghana', 11.70245383), ('Greece', 14.05690627), ('Greenland', 16.69531109), ('Grenada', 13.38709916), ('Guam', 11.38634182), ('Guatemala', 10.88260856), ('Guinea', 11.62570707), ('Guinea-Bissau', 11.65574864), ('Guyana', 14.196930300000002), ('Haiti', 13.21063548), ('High SDI', 14.07771203), ('High-income', 14.44867161), ('High-income Asia Pacific', 12.0110742), ('High-middle SDI', 12.30195484), ('Honduras', 10.511519900000001), ('Hungary', 11.19613924), ('Iceland', 13.07430478), ('India', 14.48041012), ('Indonesia', 10.19548517), ('Iran', 17.10515044), ('Iraq', 12.51640219), ('Ireland', 14.41573785), ('Israel', 12.37333434), ('Italy', 13.64377137), ('Jamaica', 13.10665571), ('Japan', 12.50892752), ('Jordan', 13.96355962), ('Kazakhstan', 11.20716643), ('Kenya', 11.94361848), ('Kiribati', 11.30531562), ('Kuwait', 13.617170499999999), ('Kyrgyzstan', 11.01629241), ('Laos', 11.68110429), ('Latin America and Caribbean', 11.93323463), ('Latvia', 11.63982479), ('Lebanon', 15.11374189), ('Lesotho', 14.14745232), ('Liberia', 11.44645072), ('Libya', 14.04713759), ('Lithuania', 12.05136588), ('Low SDI', 13.500414600000001), ('Low-middle SDI', 13.06063975), ('Luxembourg', 13.40093713), ('Macedonia', 10.80468757), ('Madagascar', 12.2000426), ('Malawi', 11.86167603), ('Malaysia', 11.46853908), ('Maldives', 10.68382982), ('Mali', 11.29643857), ('Malta', 13.23622222), ('Marshall Islands', 11.07409863), ('Mauritania', 11.58699221), ('Mauritius', 10.84595366), ('Mexico', 10.36060883), ('Micronesia (country)', 11.11215038), ('Middle SDI', 11.62930786), ('Moldova', 11.53233558), ('Mongolia', 11.27413316), ('Montenegro', 10.99537376), ('Morocco', 15.60313544), ('Mozambique', 12.33140432), ('Myanmar', 10.24095966), ('Namibia', 12.66672308), ('Nepal', 12.61085829), ('Netherlands', 14.64030937), ('New Zealand', 17.15716344), ('Nicaragua', 10.88840003), ('Niger', 12.08067733), ('Nigeria', 11.93993977), ('North Africa and Middle East', 14.78606624), ('North America', 16.17717485), ('North Korea', 11.91165531), ('Northern Ireland', 16.19748175), ('Northern Mariana Islands', 11.08982971), ('Norway', 14.74915644), ('Oceania', 11.18005491), ('Oman', 13.43155902), ('Pakistan', 11.60495993), ('Palestine', 15.82958053), ('Panama', 10.6803106), ('Papua New Guinea', 11.21753766), ('Paraguay', 12.94106664), ('Peru', 11.71187624), ('Philippines', 10.42211416), ('Poland', 11.0754087), ('Portugal', 13.982741699999998), ('Puerto Rico', 13.55617167), ('Qatar', 13.60175173), ('Romania', 10.76559147), ('Russia', 11.60781216), ('Rwanda', 12.01191881), ('Saint Lucia', 13.48585676), ('Saint Vincent and the Grenadines', 13.46445628), ('Samoa', 10.87308504), ('Sao Tome and Principe', 11.40172151), ('Saudi Arabia', 13.23259688), ('Scotland', 13.41587871), ('Senegal', 11.66275244), ('Serbia', 11.02036288), ('Seychelles', 10.55688476), ('Sierra Leone', 11.69887541), ('Singapore', 12.03986959), ('Slovakia', 10.89514031), ('Slovenia', 11.34078163), ('Solomon Islands', 11.28115855), ('Somalia', 12.95510515), ('South Africa', 12.71426357), ('South Asia', 13.87509431), ('South Korea', 11.0387813), ('South Sudan', 11.83744532), ('Southeast Asia', 10.37145833), ('Southeast Asia, East Asia, and Oceania', 11.04283763), ('Southern Latin America', 13.77071268), ('Southern Sub-Saharan Africa', 12.72121549), ('Spain', 14.45260241), ('Sri Lanka', 11.20967914), ('Sub-Saharan Africa', 12.17794106), ('Sudan', 15.90137244), ('Suriname', 14.03628633), ('Swaziland', 13.02198962), ('Sweden', 14.06287004), ('Switzerland', 13.54088115), ('Syria', 14.41073809), ('Taiwan', 11.64085994), ('Tajikistan', 10.67755916), ('Tanzania', 11.83020721), ('Thailand', 11.98569818), ('Timor', 11.16641994), ('Togo', 11.84346511), ('Tonga', 10.76304025), ('Trinidad and Tobago', 13.89966963), ('Tropical Latin America', 13.13117307), ('Tunisia', 15.06321639), ('Turkey', 14.23213201), ('Turkmenistan', 10.59856428), ('Uganda', 13.00878703), ('Ukraine', 12.07977145), ('United Arab Emirates', 12.30670712), ('United Kingdom', 14.02224704), ('United States', 16.27814981), ('United States Virgin Islands', 13.63236669), ('Uruguay', 13.75970288), ('Uzbekistan', 10.75225976), ('Vanuatu', 11.10342852), ('Venezuela', 11.186214199999998), ('Vietnam', 8.966947897), ('Wales', 13.77222513), ('Western Europe', 13.87185874), ('Western Sub-Saharan Africa', 11.84318086), ('World', 12.59527957), ('Yemen', 15.410115900000001), ('Zambia', 11.99408469), ('Zimbabwe', 12.52995425)]
[('Afghanistan', 16.71021624), ('Albania', 10.64670602), ('Algeria', 14.05290396), ('American Samoa', 10.69077718), ('Andean Latin America', 11.96637114), ('Andorra', 13.60656022), ('Angola', 12.426484), ('Antigua and Barbuda', 12.99726602), ('Argentina', 13.69433625), ('Armenia', 10.67332526), ('Australasia', 17.4553535), ('Australia', 17.50621383), ('Austria', 13.06199632), ('Azerbaijan', 10.35274919), ('Bahamas', 13.14673746), ('Bahrain', 13.92611012), ('Bangladesh', 11.64727115), ('Barbados', 13.45548259), ('Belarus', 11.98092206), ('Belgium', 14.32078129), ('Belize', 13.38485334), ('Benin', 11.89095728), ('Bermuda', 13.51341424), ('Bhutan', 11.61283902), ('Bolivia', 12.15919313), ('Bosnia and Herzegovina', 10.80790057), ('Botswana', 12.96063443), ('Brazil', 13.11279634), ('Brunei', 11.15647852), ('Bulgaria', 11.05073275), ('Burkina Faso', 11.99943482), ('Burundi', 12.51469666), ('Cambodia', 11.04409964), ('Cameroon', 11.87319041), ('Canada', 15.26142538), ('Cape Verde', 12.76174853), ('Caribbean', 13.4751294), ('Central African Republic', 12.84643674), ('Central Asia', 10.80882975), ('Central Europe', 11.02664849), ('Central Europe, Eastern Europe, and Central Asia', 11.31896693), ('Central Latin America', 10.55389565), ('Central Sub-Saharan Africa', 12.5723606), ('Chad', 12.05418303), ('Chile', 13.96068761), ('China', 11.37474847), ('Colombia', 10.41903223), ('Comoros', 11.83292893), ('Congo', 12.30198471), ('Costa Rica', 11.00020369), ("Cote d'Ivoire", 11.62149345), ('Croatia', 11.36731734), ('Cuba', 13.97813514), ('Cyprus', 13.09046045), ('Czech Republic', 11.27498223), ('Democratic Republic of Congo', 12.62671861), ('Denmark', 13.29127827), ('Djibouti', 12.23065554), ('Dominica', 13.19107443), ('Dominican Republic', 13.29205093), ('East Asia', 11.3886198), ('Eastern Europe', 11.73560382), ('Eastern Sub-Saharan Africa', 12.28903043), ('Ecuador', 12.37284264), ('Egypt', 14.27453957), ('El Salvador', 10.78682587), ('England', 14.02636086), ('Equatorial Guinea', 12.42540335), ('Eritrea', 12.37380081), ('Estonia', 11.80482266), ('Ethiopia', 12.56578118), ('Fiji', 10.95333291), ('Finland', 14.60829983), ('France', 14.253009699999998), ('Gabon', 12.50338776), ('Gambia', 11.58616941), ('Georgia', 10.75639893), ('Germany', 13.19906797), ('Ghana', 11.71799447), ('Greece', 14.03455773), ('Greenland', 16.6784536), ('Grenada', 13.38855308), ('Guam', 11.37310929), ('Guatemala', 10.87614755), ('Guinea', 11.62865492), ('Guinea-Bissau', 11.654402099999999), ('Guyana', 14.18631003), ('Haiti', 13.20732512), ('High SDI', 14.08194781), ('High-income', 14.45048431), ('High-income Asia Pacific', 12.03305726), ('High-middle SDI', 12.29957516), ('Honduras', 10.51690791), ('Hungary', 11.19284117), ('Iceland', 13.0821185), ('India', 14.46786251), ('Indonesia', 10.17136812), ('Iran', 17.08698928), ('Iraq', 12.51800342), ('Ireland', 14.41364021), ('Israel', 12.34369849), ('Italy', 13.64870785), ('Jamaica', 13.11299299), ('Japan', 12.53822497), ('Jordan', 13.96909289), ('Kazakhstan', 11.20301466), ('Kenya', 11.93844827), ('Kiribati', 11.29381122), ('Kuwait', 13.63263518), ('Kyrgyzstan', 11.00487381), ('Laos', 11.64439186), ('Latin America and Caribbean', 11.92486084), ('Latvia', 11.63970031), ('Lebanon', 15.10728679), ('Lesotho', 14.14482549), ('Liberia', 11.44114518), ('Libya', 14.10865909), ('Lithuania', 12.05518755), ('Low SDI', 13.47394634), ('Low-middle SDI', 13.04044523), ('Luxembourg', 13.40468465), ('Macedonia', 10.80539856), ('Madagascar', 12.19733348), ('Malawi', 11.89109074), ('Malaysia', 11.46069666), ('Maldives', 10.66606182), ('Mali', 11.30476882), ('Malta', 13.24287478), ('Marshall Islands', 11.05588738), ('Mauritania', 11.60322931), ('Mauritius', 10.83460462), ('Mexico', 10.37544005), ('Micronesia (country)', 11.09650301), ('Middle SDI', 11.62240304), ('Moldova', 11.52907253), ('Mongolia', 11.264455300000002), ('Montenegro', 10.99210432), ('Morocco', 15.54262384), ('Mozambique', 12.327074099999999), ('Myanmar', 10.20179744), ('Namibia', 12.69502935), ('Nepal', 12.56854261), ('Netherlands', 14.63815524), ('New Zealand', 17.16874807), ('Nicaragua', 10.88917641), ('Niger', 12.08666632), ('Nigeria', 11.89279719), ('North Africa and Middle East', 14.78218023), ('North America', 16.17217286), ('North Korea', 11.91335508), ('Northern Ireland', 16.09485002), ('Northern Mariana Islands', 11.07685271), ('Norway', 14.77511317), ('Oceania', 11.15561182), ('Oman', 13.44591763), ('Pakistan', 11.56252438), ('Palestine', 15.76949414), ('Panama', 10.68732671), ('Papua New Guinea', 11.18836611), ('Paraguay', 12.945650800000001), ('Peru', 11.71297561), ('Philippines', 10.40696226), ('Poland', 11.07101602), ('Portugal', 13.95214945), ('Puerto Rico', 13.58109413), ('Qatar', 13.59618518), ('Romania', 10.76749745), ('Russia', 11.60878055), ('Rwanda', 12.0237121), ('Saint Lucia', 13.48502511), ('Saint Vincent and the Grenadines', 13.46794519), ('Samoa', 10.86303053), ('Sao Tome and Principe', 11.4050218), ('Saudi Arabia', 13.24311077), ('Scotland', 13.42819494), ('Senegal', 11.67646742), ('Serbia', 11.02051544), ('Seychelles', 10.54183826), ('Sierra Leone', 11.69370602), ('Singapore', 12.03461238), ('Slovakia', 10.89688119), ('Slovenia', 11.33363922), ('Solomon Islands', 11.25576984), ('Somalia', 12.79575088), ('South Africa', 12.73524812), ('South Asia', 13.8536071), ('South Korea', 11.05206052), ('South Sudan', 11.84724794), ('Southeast Asia', 10.34918313), ('Southeast Asia, East Asia, and Oceania', 11.02143201), ('Southern Latin America', 13.77201993), ('Southern Sub-Saharan Africa', 12.74048576), ('Spain', 14.4570187), ('Sri Lanka', 11.18459559), ('Sub-Saharan Africa', 12.16416585), ('Sudan', 15.90842158), ('Suriname', 14.03454875), ('Swaziland', 13.04207913), ('Sweden', 14.05489787), ('Switzerland', 13.54252273), ('Syria', 14.43621294), ('Taiwan', 11.63369479), ('Tajikistan', 10.6641759), ('Tanzania', 11.84055573), ('Thailand', 11.95000942), ('Timor', 11.12956259), ('Togo', 11.84510497), ('Tonga', 10.75788618), ('Trinidad and Tobago', 13.89649934), ('Tropical Latin America', 13.10695921), ('Tunisia', 15.05752742), ('Turkey', 14.21616718), ('Turkmenistan', 10.60410194), ('Uganda', 12.99476976), ('Ukraine', 12.0808196), ('United Arab Emirates', 12.31946597), ('United Kingdom', 14.02751681), ('United States', 16.27053323), ('United States Virgin Islands', 13.63250416), ('Uruguay', 13.76256507), ('Uzbekistan', 10.74439015), ('Vanuatu', 11.09505837), ('Venezuela', 11.18449738), ('Vietnam', 8.973220702999999), ('Wales', 13.7840684), ('Western Europe', 13.86446825), ('Western Sub-Saharan Africa', 11.82457751), ('World', 12.58811415), ('Yemen', 15.45847286), ('Zambia', 12.01685488), ('Zimbabwe', 12.54659446)]
[('Afghanistan', 16.67416817), ('Albania', 10.64651811), ('Algeria', 14.06380308), ('American Samoa', 10.68793033), ('Andean Latin America', 11.97356068), ('Andorra', 13.61002276), ('Angola', 12.43669585), ('Antigua and Barbuda', 13.00821952), ('Argentina', 13.69843913), ('Armenia', 10.67906688), ('Australasia', 17.42656401), ('Australia', 17.46862358), ('Austria', 13.06481225), ('Azerbaijan', 10.36198933), ('Bahamas', 13.15329281), ('Bahrain', 13.91496228), ('Bangladesh', 11.61124711), ('Barbados', 13.46197286), ('Belarus', 11.97285592), ('Belgium', 14.32959246), ('Belize', 13.38883967), ('Benin', 11.88925815), ('Bermuda', 13.51199818), ('Bhutan', 11.614105699999998), ('Bolivia', 12.16764512), ('Bosnia and Herzegovina', 10.8099522), ('Botswana', 12.967178), ('Brazil', 13.09292581), ('Brunei', 11.16350955), ('Bulgaria', 11.05533664), ('Burkina Faso', 11.99977992), ('Burundi', 12.52197071), ('Cambodia', 11.00569858), ('Cameroon', 11.86670138), ('Canada', 15.28562543), ('Cape Verde', 12.75501296), ('Caribbean', 13.47520411), ('Central African Republic', 12.85362372), ('Central Asia', 10.8029663), ('Central Europe', 11.02671844), ('Central Europe, Eastern Europe, and Central Asia', 11.31505007), ('Central Latin America', 10.56520024), ('Central Sub-Saharan Africa', 12.56184524), ('Chad', 12.04486783), ('Chile', 13.967695), ('China', 11.35249761), ('Colombia', 10.43344509), ('Comoros', 11.85924207), ('Congo', 12.31508087), ('Costa Rica', 11.00603676), ("Cote d'Ivoire", 11.64569968), ('Croatia', 11.36712535), ('Cuba', 13.97620114), ('Cyprus', 13.09818835), ('Czech Republic', 11.27347261), ('Democratic Republic of Congo', 12.60708532), ('Denmark', 13.28569218), ('Djibouti', 12.24017226), ('Dominica', 13.19952446), ('Dominican Republic', 13.29665253), ('East Asia', 11.36693767), ('Eastern Europe', 11.73492916), ('Eastern Sub-Saharan Africa', 12.27593371), ('Ecuador', 12.38856483), ('Egypt', 14.29446933), ('El Salvador', 10.78907826), ('England', 14.03463551), ('Equatorial Guinea', 12.43594893), ('Eritrea', 12.37119592), ('Estonia', 11.80539473), ('Ethiopia', 12.53710899), ('Fiji', 10.95245987), ('Finland', 14.58086006), ('France', 14.25309767), ('Gabon', 12.506091), ('Gambia', 11.60140376), ('Georgia', 10.76457749), ('Germany', 13.17717679), ('Ghana', 11.73997671), ('Greece', 14.0109792), ('Greenland', 16.66093702), ('Grenada', 13.39275462), ('Guam', 11.36081544), ('Guatemala', 10.87408272), ('Guinea', 11.62885985), ('Guinea-Bissau', 11.65543595), ('Guyana', 14.17509458), ('Haiti', 13.20468727), ('High SDI', 14.08900942), ('High-income', 14.45598174), ('High-income Asia Pacific', 12.05491117), ('High-middle SDI', 12.29541915), ('Honduras', 10.52434945), ('Hungary', 11.197610800000001), ('Iceland', 13.08986919), ('India', 14.45885164), ('Indonesia', 10.15248794), ('Iran', 17.05942369), ('Iraq', 12.53082199), ('Ireland', 14.41110801), ('Israel', 12.31986302), ('Italy', 13.657126199999999), ('Jamaica', 13.12333348), ('Japan', 12.56811524), ('Jordan', 13.9798924), ('Kazakhstan', 11.20393598), ('Kenya', 11.93529175), ('Kiribati', 11.2850625), ('Kuwait', 13.65292554), ('Kyrgyzstan', 10.997480099999999), ('Laos', 11.61248718), ('Latin America and Caribbean', 11.91924202), ('Latvia', 11.64982837), ('Lebanon', 15.09501885), ('Lesotho', 14.14159748), ('Liberia', 11.42404899), ('Libya', 14.17841664), ('Lithuania', 12.0622496), ('Low SDI', 13.44856223), ('Low-middle SDI', 13.02148124), ('Luxembourg', 13.40541934), ('Macedonia', 10.80843731), ('Madagascar', 12.19106951), ('Malawi', 11.922353999999999), ('Malaysia', 11.45581441), ('Maldives', 10.65300923), ('Mali', 11.31907313), ('Malta', 13.25747182), ('Marshall Islands', 11.03854769), ('Mauritania', 11.62124395), ('Mauritius', 10.82834539), ('Mexico', 10.39246595), ('Micronesia (country)', 11.08075622), ('Middle SDI', 11.61658385), ('Moldova', 11.52270092), ('Mongolia', 11.25406267), ('Montenegro', 10.99517127), ('Morocco', 15.47840828), ('Mozambique', 12.32834321), ('Myanmar', 10.17073899), ('Namibia', 12.73008843), ('Nepal', 12.52838711), ('Netherlands', 14.63224271), ('New Zealand', 17.18089865), ('Nicaragua', 10.88790481), ('Niger', 12.09100472), ('Nigeria', 11.83557218), ('North Africa and Middle East', 14.7801783), ('North America', 16.16828833), ('North Korea', 11.91595804), ('Northern Ireland', 15.97895436), ('Northern Mariana Islands', 11.068200099999999), ('Norway', 14.80513401), ('Oceania', 11.13128848), ('Oman', 13.46183451), ('Pakistan', 11.52209368), ('Palestine', 15.70642814), ('Panama', 10.70246104), ('Papua New Guinea', 11.15925308), ('Paraguay', 12.95005176), ('Peru', 11.71555393), ('Philippines', 10.39104478), ('Poland', 11.06641284), ('Portugal', 13.91262674), ('Puerto Rico', 13.61382087), ('Qatar', 13.59611741), ('Romania', 10.77483797), ('Russia', 11.61144037), ('Rwanda', 12.04162058), ('Saint Lucia', 13.48582736), ('Saint Vincent and the Grenadines', 13.474190599999998), ('Samoa', 10.85143129), ('Sao Tome and Principe', 11.41433574), ('Saudi Arabia', 13.25645543), ('Scotland', 13.44656424), ('Senegal', 11.69102167), ('Serbia', 11.01673013), ('Seychelles', 10.52810266), ('Sierra Leone', 11.68906926), ('Singapore', 12.0350557), ('Slovakia', 10.89585216), ('Slovenia', 11.33071529), ('Solomon Islands', 11.229545199999999), ('Somalia', 12.5931244), ('South Africa', 12.75893546), ('South Asia', 13.83438991), ('South Korea', 11.06356522), ('South Sudan', 11.85204781), ('Southeast Asia', 10.33147405), ('Southeast Asia, East Asia, and Oceania', 11.00054655), ('Southern Latin America', 13.77690148), ('Southern Sub-Saharan Africa', 12.76207642), ('Spain', 14.45882611), ('Sri Lanka', 11.15209358), ('Sub-Saharan Africa', 12.14966965), ('Sudan', 15.92035535), ('Suriname', 14.03425226), ('Swaziland', 13.06597094), ('Sweden', 14.04922185), ('Switzerland', 13.5581555), ('Syria', 14.45703852), ('Taiwan', 11.62466188), ('Tajikistan', 10.64944954), ('Tanzania', 11.85559758), ('Thailand', 11.91876723), ('Timor', 11.09480421), ('Togo', 11.84631867), ('Tonga', 10.75631418), ('Trinidad and Tobago', 13.89919098), ('Tropical Latin America', 13.087585800000001), ('Tunisia', 15.05246048), ('Turkey', 14.19673292), ('Turkmenistan', 10.60866465), ('Uganda', 12.97685878), ('Ukraine', 12.07512714), ('United Arab Emirates', 12.32482273), ('United Kingdom', 14.033961699999999), ('United States', 16.26387429), ('United States Virgin Islands', 13.63259525), ('Uruguay', 13.77504167), ('Uzbekistan', 10.73137001), ('Vanuatu', 11.08565901), ('Venezuela', 11.18188559), ('Vietnam', 8.988939185), ('Wales', 13.80581111), ('Western Europe', 13.86118205), ('Western Sub-Saharan Africa', 11.80157631), ('World', 12.58119894), ('Yemen', 15.51480665), ('Zambia', 12.04729227), ('Zimbabwe', 12.56106349)]
import pandas as pd
import numpy as np
from pyecharts.charts import Geo
from pyecharts import options as opts
from pyecharts.globals import ChartType, SymbolType,ThemeType
from pyecharts.charts import Bar,Tab,Line,Map,Timeline
def timeline_map() -> Timeline:
tl = Timeline()
for i in range(2014,2018):
map0 = (
Map()
.add(
"男性患病率",list(zip(list(df.Country),list(df["{}年".format(i)]))),"world",is_map_symbol_show = False
)
.set_global_opts(
title_opts=opts.TitleOpts(title="{}年男性患病率".format(i),subtitle="",
subtitle_textstyle_opts=opts.TextStyleOpts(color="red",font_size=18,font_style="italic")),
visualmap_opts=opts.VisualMapOpts(min_= 8.96,max_=17.6)
)
)
tl.add(map0,"{}年".format(i))
return tl
timeline_map().render_notebook()
df = pd.read_csv('country_females.csv',encoding='gbk')
df
| Country | 2014年 | 2015年 | 2016年 | 2017年 | |
|---|---|---|---|---|---|
| 0 | Afghanistan | 17.085561 | 17.041232 | 17.002182 | 16.963023 |
| 1 | Albania | 11.065094 | 11.058989 | 11.045554 | 11.043173 |
| 2 | Algeria | 14.980180 | 14.986809 | 14.994890 | 15.011597 |
| 3 | American Samoa | 11.007858 | 11.007287 | 11.002724 | 11.004269 |
| 4 | Andean Latin America | 12.789837 | 12.789660 | 12.788287 | 12.787111 |
| 5 | Andorra | 15.846479 | 15.850925 | 15.855442 | 15.861840 |
| 6 | Angola | 12.328792 | 12.327245 | 12.322599 | 12.322946 |
| 7 | Antigua and Barbuda | 13.368135 | 13.375635 | 13.381903 | 13.392391 |
| 8 | Argentina | 17.564053 | 17.573386 | 17.583533 | 17.598748 |
| 9 | Armenia | 10.547196 | 10.553468 | 10.564378 | 10.574900 |
| 10 | Australasia | 19.471482 | 19.436418 | 19.395227 | 19.354329 |
| 11 | Australia | 19.352941 | 19.311627 | 19.264186 | 19.216194 |
| 12 | Austria | 15.589555 | 15.589782 | 15.591026 | 15.600716 |
| 13 | Azerbaijan | 10.368040 | 10.377675 | 10.396507 | 10.416485 |
| 14 | Bahamas | 13.478457 | 13.481507 | 13.487294 | 13.491201 |
| 15 | Bahrain | 14.850438 | 14.833887 | 14.822228 | 14.816274 |
| 16 | Bangladesh | 13.467970 | 13.408453 | 13.348796 | 13.289032 |
| 17 | Barbados | 13.590267 | 13.596185 | 13.596342 | 13.602635 |
| 18 | Belarus | 12.098269 | 12.091812 | 12.087286 | 12.081957 |
| 19 | Belgium | 15.630786 | 15.639846 | 15.643901 | 15.653381 |
| 20 | Belize | 13.461596 | 13.465908 | 13.468690 | 13.472870 |
| 21 | Benin | 11.688219 | 11.691759 | 11.690371 | 11.693028 |
| 22 | Bermuda | 13.915670 | 13.910826 | 13.907828 | 13.902880 |
| 23 | Bhutan | 12.208802 | 12.216368 | 12.229395 | 12.241409 |
| 24 | Bolivia | 13.346936 | 13.339368 | 13.324520 | 13.311968 |
| 25 | Bosnia and Herzegovina | 11.109441 | 11.103246 | 11.093431 | 11.091413 |
| 26 | Botswana | 12.137819 | 12.132886 | 12.128188 | 12.127932 |
| 27 | Brazil | 16.073385 | 15.980628 | 15.886907 | 15.792622 |
| 28 | Brunei | 11.705006 | 11.713503 | 11.730316 | 11.743905 |
| 29 | Bulgaria | 11.379093 | 11.377511 | 11.372656 | 11.374022 |
| ... | ... | ... | ... | ... | ... |
| 201 | Taiwan | 11.352653 | 11.348627 | 11.344796 | 11.338834 |
| 202 | Tajikistan | 10.688414 | 10.676713 | 10.667650 | 10.659094 |
| 203 | Tanzania | 12.824194 | 12.834891 | 12.845311 | 12.857774 |
| 204 | Thailand | 11.622408 | 11.602588 | 11.589454 | 11.578325 |
| 205 | Timor | 12.280247 | 12.233449 | 12.188151 | 12.164470 |
| 206 | Togo | 11.660370 | 11.654846 | 11.647139 | 11.644117 |
| 207 | Tonga | 11.137072 | 11.131282 | 11.127248 | 11.120704 |
| 208 | Trinidad and Tobago | 14.139536 | 14.140235 | 14.138539 | 14.133760 |
| 209 | Tropical Latin America | 16.054149 | 15.963876 | 15.872559 | 15.780627 |
| 210 | Tunisia | 15.474682 | 15.467767 | 15.463897 | 15.465274 |
| 211 | Turkey | 14.424071 | 14.398836 | 14.377817 | 14.355624 |
| 212 | Turkmenistan | 10.598133 | 10.601733 | 10.607301 | 10.613201 |
| 213 | Uganda | 13.930397 | 13.883849 | 13.835766 | 13.790202 |
| 214 | Ukraine | 12.035598 | 12.015691 | 12.002457 | 11.993509 |
| 215 | United Arab Emirates | 12.982289 | 12.985515 | 12.981067 | 12.977993 |
| 216 | United Kingdom | 15.209811 | 15.213827 | 15.216007 | 15.216455 |
| 217 | United States | 18.293735 | 18.304311 | 18.321319 | 18.347446 |
| 218 | United States Virgin Islands | 13.922081 | 13.918943 | 13.904578 | 13.892177 |
| 219 | Uruguay | 17.466979 | 17.494140 | 17.524876 | 17.557468 |
| 220 | Uzbekistan | 10.642068 | 10.637069 | 10.630145 | 10.625033 |
| 221 | Vanuatu | 11.335068 | 11.330315 | 11.326689 | 11.318353 |
| 222 | Venezuela | 10.997758 | 11.002820 | 11.002089 | 11.003374 |
| 223 | Vietnam | 10.413027 | 10.385800 | 10.359497 | 10.346828 |
| 224 | Wales | 15.191740 | 15.206088 | 15.227745 | 15.248820 |
| 225 | Western Europe | 16.679503 | 16.676422 | 16.674511 | 16.669722 |
| 226 | Western Sub-Saharan Africa | 11.918384 | 11.883468 | 11.846144 | 11.802223 |
| 227 | World | 13.288238 | 13.273091 | 13.259132 | 13.245729 |
| 228 | Yemen | 16.230133 | 16.247524 | 16.267155 | 16.296067 |
| 229 | Zambia | 12.421706 | 12.449468 | 12.485455 | 12.528861 |
| 230 | Zimbabwe | 10.698576 | 10.709341 | 10.728702 | 10.740696 |
231 rows × 5 columns
for i in range(2014,2018):
print(list(zip(list(df.Country),list(df["{}年".format(i)]))))
[('Afghanistan', 17.08556095), ('Albania', 11.06509446), ('Algeria', 14.9801801), ('American Samoa', 11.00785834), ('Andean Latin America', 12.78983672), ('Andorra', 15.8464789), ('Angola', 12.32879173), ('Antigua and Barbuda', 13.36813484), ('Argentina', 17.564053), ('Armenia', 10.54719553), ('Australasia', 19.47148217), ('Australia', 19.35294106), ('Austria', 15.58955485), ('Azerbaijan', 10.36804019), ('Bahamas', 13.4784566), ('Bahrain', 14.85043772), ('Bangladesh', 13.46797023), ('Barbados', 13.59026728), ('Belarus', 12.09826934), ('Belgium', 15.63078606), ('Belize', 13.46159557), ('Benin', 11.68821929), ('Bermuda', 13.91567014), ('Bhutan', 12.20880225), ('Bolivia', 13.34693612), ('Bosnia and Herzegovina', 11.10944104), ('Botswana', 12.13781927), ('Brazil', 16.07338495), ('Brunei', 11.70500608), ('Bulgaria', 11.37909341), ('Burkina Faso', 11.63588453), ('Burundi', 13.30031967), ('Cambodia', 12.01212422), ('Cameroon', 11.76661899), ('Canada', 15.58759443), ('Cape Verde', 11.91864496), ('Caribbean', 13.86154011), ('Central African Republic', 12.53674819), ('Central Asia', 10.74605766), ('Central Europe', 11.08405871), ('Central Europe, Eastern Europe, and Central Asia', 11.35456446), ('Central Latin America', 10.85273094), ('Central Sub-Saharan Africa', 12.37874564), ('Chad', 12.15723494), ('Chile', 17.96308737), ('China', 11.48426535), ('Colombia', 9.632327983), ('Comoros', 12.61376748), ('Congo', 12.33148289), ('Costa Rica', 11.03708169), ("Cote d'Ivoire", 11.28995946), ('Croatia', 11.48264852), ('Cuba', 14.18037979), ('Cyprus', 15.26030381), ('Czech Republic', 11.37163817), ('Democratic Republic of Congo', 12.39542441), ('Denmark', 15.19892891), ('Djibouti', 12.90746703), ('Dominica', 13.32992407), ('Dominican Republic', 13.83403312), ('East Asia', 11.484414), ('Eastern Europe', 11.75255368), ('Eastern Sub-Saharan Africa', 13.05691123), ('Ecuador', 13.15445316), ('Egypt', 14.91369743), ('El Salvador', 11.14779666), ('England', 15.08792628), ('Equatorial Guinea', 12.36468135), ('Eritrea', 13.13257283), ('Estonia', 12.16714119), ('Ethiopia', 13.17492583), ('Fiji', 11.26595207), ('Finland', 15.24382339), ('France', 18.42542302), ('Gabon', 12.12128424), ('Gambia', 12.84794201), ('Georgia', 10.63516604), ('Germany', 17.05964959), ('Ghana', 11.23317079), ('Greece', 17.01410035), ('Greenland', 18.96616248), ('Grenada', 13.38025545), ('Guam', 11.40425186), ('Guatemala', 11.45754852), ('Guinea', 11.67693218), ('Guinea-Bissau', 11.75074964), ('Guyana', 14.89603738), ('Haiti', 13.71900994), ('High SDI', 15.70781801), ('High-income', 16.52843241), ('High-income Asia Pacific', 12.14833066), ('High-middle SDI', 12.973338499999999), ('Honduras', 10.82531736), ('Hungary', 11.465229699999998), ('Iceland', 15.30060223), ('India', 14.58751197), ('Indonesia', 11.15776595), ('Iran', 18.46044898), ('Iraq', 14.82691636), ('Ireland', 16.75541213), ('Israel', 13.23209279), ('Italy', 16.01317492), ('Jamaica', 13.3397345), ('Japan', 12.00794468), ('Jordan', 14.81260653), ('Kazakhstan', 11.11179553), ('Kenya', 12.66404014), ('Kiribati', 11.35497111), ('Kuwait', 14.81970221), ('Kyrgyzstan', 10.91394311), ('Laos', 12.50778588), ('Latin America and Caribbean', 13.32469336), ('Latvia', 11.44992698), ('Lebanon', 16.78971421), ('Lesotho', 13.89377353), ('Liberia', 12.70904868), ('Libya', 14.92395859), ('Lithuania', 12.15313438), ('Low SDI', 13.78173952), ('Low-middle SDI', 13.60106231), ('Luxembourg', 15.82314335), ('Macedonia', 11.15043352), ('Madagascar', 12.94608303), ('Malawi', 12.51908061), ('Malaysia', 12.88767593), ('Maldives', 11.74590044), ('Mali', 11.07997252), ('Malta', 15.36658548), ('Marshall Islands', 11.29662578), ('Mauritania', 10.95288213), ('Mauritius', 11.85798554), ('Mexico', 11.23854226), ('Micronesia (country)', 11.30163585), ('Middle SDI', 12.09021902), ('Moldova', 11.48335119), ('Mongolia', 11.13048797), ('Montenegro', 11.39724837), ('Morocco', 17.0540544), ('Mozambique', 13.02699958), ('Myanmar', 10.85637376), ('Namibia', 11.42149458), ('Nepal', 13.18940849), ('Netherlands', 17.29369285), ('New Zealand', 20.07164768), ('Nicaragua', 11.00113084), ('Niger', 11.97794866), ('Nigeria', 12.31456509), ('North Africa and Middle East', 15.811789000000001), ('North America', 18.0277736), ('North Korea', 11.63529289), ('Northern Ireland', 19.00262748), ('Northern Mariana Islands', 11.007330300000001), ('Norway', 17.29037397), ('Oceania', 11.49313336), ('Oman', 14.44350766), ('Pakistan', 12.45835737), ('Palestine', 16.25876809), ('Panama', 10.79401557), ('Papua New Guinea', 11.54791281), ('Paraguay', 15.40613262), ('Peru', 12.43431439), ('Philippines', 11.273072099999998), ('Poland', 10.8444472), ('Portugal', 16.76627267), ('Puerto Rico', 13.46867686), ('Qatar', 14.68837377), ('Romania', 10.79198582), ('Russia', 11.63744415), ('Rwanda', 13.154594699999999), ('Saint Lucia', 13.49827644), ('Saint Vincent and the Grenadines', 13.37238501), ('Samoa', 11.10760141), ('Sao Tome and Principe', 11.23567579), ('Saudi Arabia', 14.27178571), ('Scotland', 15.08036893), ('Senegal', 11.15388249), ('Serbia', 11.310729400000001), ('Seychelles', 11.08355067), ('Sierra Leone', 11.82458013), ('Singapore', 12.81949454), ('Slovakia', 11.17661205), ('Slovenia', 11.74992431), ('Solomon Islands', 11.56064047), ('Somalia', 13.8338881), ('South Africa', 12.66928916), ('South Asia', 14.18542108), ('South Korea', 12.43937347), ('South Sudan', 12.8319849), ('Southeast Asia', 11.23091253), ('Southeast Asia, East Asia, and Oceania', 11.43873612), ('Southern Latin America', 17.67024528), ('Southern Sub-Saharan Africa', 12.30090412), ('Spain', 17.76147156), ('Sri Lanka', 11.86350377), ('Sub-Saharan Africa', 12.41963738), ('Sudan', 16.21891755), ('Suriname', 14.71018869), ('Swaziland', 11.97373439), ('Sweden', 17.08805091), ('Switzerland', 16.11780089), ('Syria', 15.11277311), ('Taiwan', 11.35265277), ('Tajikistan', 10.68841414), ('Tanzania', 12.8241939), ('Thailand', 11.62240806), ('Timor', 12.28024655), ('Togo', 11.66037037), ('Tonga', 11.137072300000002), ('Trinidad and Tobago', 14.13953557), ('Tropical Latin America', 16.05414877), ('Tunisia', 15.47468194), ('Turkey', 14.42407075), ('Turkmenistan', 10.59813308), ('Uganda', 13.93039659), ('Ukraine', 12.03559817), ('United Arab Emirates', 12.98228907), ('United Kingdom', 15.20981111), ('United States', 18.29373474), ('United States Virgin Islands', 13.92208138), ('Uruguay', 17.46697911), ('Uzbekistan', 10.64206847), ('Vanuatu', 11.33506779), ('Venezuela', 10.99775797), ('Vietnam', 10.41302677), ('Wales', 15.19174013), ('Western Europe', 16.67950296), ('Western Sub-Saharan Africa', 11.91838393), ('World', 13.28823829), ('Yemen', 16.23013339), ('Zambia', 12.42170615), ('Zimbabwe', 10.69857563)]
[('Afghanistan', 17.04123159), ('Albania', 11.05898907), ('Algeria', 14.98680857), ('American Samoa', 11.00728657), ('Andean Latin America', 12.78966008), ('Andorra', 15.85092539), ('Angola', 12.32724532), ('Antigua and Barbuda', 13.37563503), ('Argentina', 17.57338608), ('Armenia', 10.55346793), ('Australasia', 19.43641821), ('Australia', 19.31162687), ('Austria', 15.58978164), ('Azerbaijan', 10.37767506), ('Bahamas', 13.48150673), ('Bahrain', 14.83388721), ('Bangladesh', 13.40845331), ('Barbados', 13.59618453), ('Belarus', 12.09181166), ('Belgium', 15.63984601), ('Belize', 13.46590766), ('Benin', 11.69175908), ('Bermuda', 13.91082573), ('Bhutan', 12.21636758), ('Bolivia', 13.33936752), ('Bosnia and Herzegovina', 11.10324625), ('Botswana', 12.13288612), ('Brazil', 15.98062829), ('Brunei', 11.71350337), ('Bulgaria', 11.37751052), ('Burkina Faso', 11.65336127), ('Burundi', 13.29614687), ('Cambodia', 11.95728409), ('Cameroon', 11.75759742), ('Canada', 15.60581554), ('Cape Verde', 11.92664828), ('Caribbean', 13.853194400000001), ('Central African Republic', 12.53188381), ('Central Asia', 10.74211365), ('Central Europe', 11.07937311), ('Central Europe, Eastern Europe, and Central Asia', 11.35116846), ('Central Latin America', 10.85673833), ('Central Sub-Saharan Africa', 12.36348428), ('Chad', 12.14684423), ('Chile', 17.97997361), ('China', 11.44172054), ('Colombia', 9.626802857000001), ('Comoros', 12.63433271), ('Congo', 12.30342559), ('Costa Rica', 11.04821386), ("Cote d'Ivoire", 11.31328007), ('Croatia', 11.47940048), ('Cuba', 14.17526739), ('Cyprus', 15.27357845), ('Czech Republic', 11.36605273), ('Democratic Republic of Congo', 12.37553114), ('Denmark', 15.20322517), ('Djibouti', 12.91667752), ('Dominica', 13.3369473), ('Dominican Republic', 13.81494558), ('East Asia', 11.44339695), ('Eastern Europe', 11.75584313), ('Eastern Sub-Saharan Africa', 13.04739864), ('Ecuador', 13.16350094), ('Egypt', 14.895161100000001), ('El Salvador', 11.15137275), ('England', 15.09687251), ('Equatorial Guinea', 12.37488853), ('Eritrea', 13.13339732), ('Estonia', 12.13682776), ('Ethiopia', 13.15561085), ('Fiji', 11.26756938), ('Finland', 15.22297279), ('France', 18.39346095), ('Gabon', 12.11955986), ('Gambia', 12.85864818), ('Georgia', 10.62895059), ('Germany', 17.07222876), ('Ghana', 11.23945494), ('Greece', 16.99186229), ('Greenland', 18.93264181), ('Grenada', 13.38399649), ('Guam', 11.39938801), ('Guatemala', 11.4283476), ('Guinea', 11.67091734), ('Guinea-Bissau', 11.7506278), ('Guyana', 14.87592012), ('Haiti', 13.70668715), ('High SDI', 15.72408152), ('High-income', 16.54555277), ('High-income Asia Pacific', 12.18656157), ('High-middle SDI', 12.95866274), ('Honduras', 10.82948807), ('Hungary', 11.47133144), ('Iceland', 15.30999554), ('India', 14.578340099999998), ('Indonesia', 11.12941659), ('Iran', 18.44580534), ('Iraq', 14.84367268), ('Ireland', 16.74250888), ('Israel', 13.18353904), ('Italy', 16.01885689), ('Jamaica', 13.34936337), ('Japan', 12.04650823), ('Jordan', 14.80597552), ('Kazakhstan', 11.11258317), ('Kenya', 12.65742289), ('Kiribati', 11.34962025), ('Kuwait', 14.82875499), ('Kyrgyzstan', 10.90447833), ('Laos', 12.45882617), ('Latin America and Caribbean', 13.28518235), ('Latvia', 11.45276546), ('Lebanon', 16.76555856), ('Lesotho', 13.88832992), ('Liberia', 12.70895508), ('Libya', 14.95075317), ('Lithuania', 12.14959093), ('Low SDI', 13.75747408), ('Low-middle SDI', 13.57095182), ('Luxembourg', 15.82730838), ('Macedonia', 11.14716055), ('Madagascar', 12.94244631), ('Malawi', 12.54669786), ('Malaysia', 12.87614956), ('Maldives', 11.71328444), ('Mali', 11.09483573), ('Malta', 15.38739178), ('Marshall Islands', 11.29368274), ('Mauritania', 10.97112565), ('Mauritius', 11.83101152), ('Mexico', 11.24883863), ('Micronesia (country)', 11.29505054), ('Middle SDI', 12.07642404), ('Moldova', 11.47644231), ('Mongolia', 11.11988022), ('Montenegro', 11.38894447), ('Morocco', 16.9875338), ('Mozambique', 13.02839807), ('Myanmar', 10.81291681), ('Namibia', 11.43594065), ('Nepal', 13.1294337), ('Netherlands', 17.31961801), ('New Zealand', 20.07527465), ('Nicaragua', 11.00058335), ('Niger', 11.97832949), ('Nigeria', 12.23187035), ('North Africa and Middle East', 15.79619992), ('North America', 18.03931677), ('North Korea', 11.63715895), ('Northern Ireland', 18.83534447), ('Northern Mariana Islands', 11.00565333), ('Norway', 17.33261021), ('Oceania', 11.47501858), ('Oman', 14.45560152), ('Pakistan', 12.44390191), ('Palestine', 16.21274044), ('Panama', 10.80721042), ('Papua New Guinea', 11.52465074), ('Paraguay', 15.41241974), ('Peru', 12.43184844), ('Philippines', 11.251221800000001), ('Poland', 10.83154037), ('Portugal', 16.69608786), ('Puerto Rico', 13.4801573), ('Qatar', 14.69193372), ('Romania', 10.79402323), ('Russia', 11.64995613), ('Rwanda', 13.16916418), ('Saint Lucia', 13.50280161), ('Saint Vincent and the Grenadines', 13.37613765), ('Samoa', 11.10115723), ('Sao Tome and Principe', 11.24529919), ('Saudi Arabia', 14.28440005), ('Scotland', 15.08931467), ('Senegal', 11.18176874), ('Serbia', 11.30855972), ('Seychelles', 11.07891175), ('Sierra Leone', 11.81150856), ('Singapore', 12.81789866), ('Slovakia', 11.17547921), ('Slovenia', 11.74235047), ('Solomon Islands', 11.54384229), ('Somalia', 13.73265334), ('South Africa', 12.67546716), ('South Asia', 14.16855339), ('South Korea', 12.47433986), ('South Sudan', 12.8380209), ('Southeast Asia', 11.20280725), ('Southeast Asia, East Asia, and Oceania', 11.40090795), ('Southern Latin America', 17.68212403), ('Southern Sub-Saharan Africa', 12.30335021), ('Spain', 17.77679358), ('Sri Lanka', 11.82123437), ('Sub-Saharan Africa', 12.3994728), ('Sudan', 16.21404621), ('Suriname', 14.70555246), ('Swaziland', 11.9784347), ('Sweden', 17.08094663), ('Switzerland', 16.11408377), ('Syria', 15.129428), ('Taiwan', 11.34862742), ('Tajikistan', 10.67671269), ('Tanzania', 12.83489087), ('Thailand', 11.60258762), ('Timor', 12.23344899), ('Togo', 11.65484564), ('Tonga', 11.13128195), ('Trinidad and Tobago', 14.14023535), ('Tropical Latin America', 15.96387612), ('Tunisia', 15.46776713), ('Turkey', 14.39883626), ('Turkmenistan', 10.60173329), ('Uganda', 13.88384851), ('Ukraine', 12.01569106), ('United Arab Emirates', 12.985515), ('United Kingdom', 15.21382671), ('United States', 18.30431071), ('United States Virgin Islands', 13.91894284), ('Uruguay', 17.4941402), ('Uzbekistan', 10.63706923), ('Vanuatu', 11.33031515), ('Venezuela', 11.00281995), ('Vietnam', 10.38579953), ('Wales', 15.20608772), ('Western Europe', 16.67642179), ('Western Sub-Saharan Africa', 11.88346824), ('World', 13.27309115), ('Yemen', 16.24752402), ('Zambia', 12.44946808), ('Zimbabwe', 10.70934073)]
[('Afghanistan', 17.00218203), ('Albania', 11.04555426), ('Algeria', 14.99488952), ('American Samoa', 11.00272418), ('Andean Latin America', 12.78828692), ('Andorra', 15.85544215), ('Angola', 12.32259927), ('Antigua and Barbuda', 13.38190308), ('Argentina', 17.58353313), ('Armenia', 10.56437823), ('Australasia', 19.39522744), ('Australia', 19.26418635), ('Austria', 15.59102598), ('Azerbaijan', 10.39650695), ('Bahamas', 13.48729409), ('Bahrain', 14.82222768), ('Bangladesh', 13.34879581), ('Barbados', 13.59634213), ('Belarus', 12.08728599), ('Belgium', 15.64390109), ('Belize', 13.46868986), ('Benin', 11.69037073), ('Bermuda', 13.90782755), ('Bhutan', 12.22939543), ('Bolivia', 13.32452034), ('Bosnia and Herzegovina', 11.09343139), ('Botswana', 12.12818832), ('Brazil', 15.88690681), ('Brunei', 11.730316199999999), ('Bulgaria', 11.37265632), ('Burkina Faso', 11.6735383), ('Burundi', 13.30293926), ('Cambodia', 11.9083853), ('Cameroon', 11.75870492), ('Canada', 15.63876401), ('Cape Verde', 11.93298973), ('Caribbean', 13.84329507), ('Central African Republic', 12.52847966), ('Central Asia', 10.74163945), ('Central Europe', 11.07898906), ('Central Europe, Eastern Europe, and Central Asia', 11.35163322), ('Central Latin America', 10.8631089), ('Central Sub-Saharan Africa', 12.35161213), ('Chad', 12.13670868), ('Chile', 18.00337628), ('China', 11.39733557), ('Colombia', 9.625504409), ('Comoros', 12.66536092), ('Congo', 12.2741678), ('Costa Rica', 11.05554876), ("Cote d'Ivoire", 11.33917175), ('Croatia', 11.47674741), ('Cuba', 14.172139999999999), ('Cyprus', 15.295353699999998), ('Czech Republic', 11.36152757), ('Democratic Republic of Congo', 12.36157261), ('Denmark', 15.20988452), ('Djibouti', 12.92327875), ('Dominica', 13.34736067), ('Dominican Republic', 13.79354897), ('East Asia', 11.40060649), ('Eastern Europe', 11.76426092), ('Eastern Sub-Saharan Africa', 13.04058679), ('Ecuador', 13.16929306), ('Egypt', 14.87237139), ('El Salvador', 11.15421783), ('England', 15.10480558), ('Equatorial Guinea', 12.38498753), ('Eritrea', 13.14219267), ('Estonia', 12.11237189), ('Ethiopia', 13.14283151), ('Fiji', 11.26860138), ('Finland', 15.19947877), ('France', 18.36053019), ('Gabon', 12.11904206), ('Gambia', 12.87632545), ('Georgia', 10.62533878), ('Germany', 17.08601202), ('Ghana', 11.24777417), ('Greece', 16.97137764), ('Greenland', 18.88850525), ('Grenada', 13.39079721), ('Guam', 11.3936007), ('Guatemala', 11.40363727), ('Guinea', 11.6697564), ('Guinea-Bissau', 11.74559805), ('Guyana', 14.84643641), ('Haiti', 13.68671578), ('High SDI', 15.74420173), ('High-income', 16.56570409), ('High-income Asia Pacific', 12.22746323), ('High-middle SDI', 12.94294634), ('Honduras', 10.83581472), ('Hungary', 11.4831874), ('Iceland', 15.31906977), ('India', 14.57293018), ('Indonesia', 11.10425185), ('Iran', 18.41754239), ('Iraq', 14.86424871), ('Ireland', 16.72917805), ('Israel', 13.12360566), ('Italy', 16.03008006), ('Jamaica', 13.36079193), ('Japan', 12.0869274), ('Jordan', 14.80128188), ('Kazakhstan', 11.12129161), ('Kenya', 12.65421265), ('Kiribati', 11.34559262), ('Kuwait', 14.83974952), ('Kyrgyzstan', 10.90333669), ('Laos', 12.419564999999999), ('Latin America and Caribbean', 13.24604883), ('Latvia', 11.45754027), ('Lebanon', 16.72888373), ('Lesotho', 13.88637038), ('Liberia', 12.70813718), ('Libya', 14.98324496), ('Lithuania', 12.15150879), ('Low SDI', 13.73277205), ('Low-middle SDI', 13.54203547), ('Luxembourg', 15.833039499999998), ('Macedonia', 11.14514949), ('Madagascar', 12.95233282), ('Malawi', 12.5758552), ('Malaysia', 12.86970882), ('Maldives', 11.68662788), ('Mali', 11.11003883), ('Malta', 15.41195154), ('Marshall Islands', 11.27742617), ('Mauritania', 10.99702431), ('Mauritius', 11.80360278), ('Mexico', 11.26254944), ('Micronesia (country)', 11.27987957), ('Middle SDI', 12.06363026), ('Moldova', 11.47262711), ('Mongolia', 11.11696537), ('Montenegro', 11.37715002), ('Morocco', 16.91406701), ('Mozambique', 13.02791512), ('Myanmar', 10.78032372), ('Namibia', 11.45166801), ('Nepal', 13.06634926), ('Netherlands', 17.35618529), ('New Zealand', 20.07409026), ('Nicaragua', 11.00553286), ('Niger', 11.97898012), ('Nigeria', 12.14162811), ('North Africa and Middle East', 15.77925432), ('North America', 18.05806252), ('North Korea', 11.63925704), ('Northern Ireland', 18.65269609), ('Northern Mariana Islands', 11.00141243), ('Norway', 17.38268333), ('Oceania', 11.45428933), ('Oman', 14.46550437), ('Pakistan', 12.43235855), ('Palestine', 16.15536666), ('Panama', 10.82541884), ('Papua New Guinea', 11.49853144), ('Paraguay', 15.41372278), ('Peru', 12.43026911), ('Philippines', 11.23095841), ('Poland', 10.82965151), ('Portugal', 16.62825065), ('Puerto Rico', 13.49490718), ('Qatar', 14.69975598), ('Romania', 10.79633631), ('Russia', 11.66722744), ('Rwanda', 13.18795676), ('Saint Lucia', 13.50422605), ('Saint Vincent and the Grenadines', 13.37455344), ('Samoa', 11.09144479), ('Sao Tome and Principe', 11.2511991), ('Saudi Arabia', 14.30205821), ('Scotland', 15.08760199), ('Senegal', 11.20992184), ('Serbia', 11.309071800000002), ('Seychelles', 11.07425995), ('Sierra Leone', 11.79944645), ('Singapore', 12.81862776), ('Slovakia', 11.17732283), ('Slovenia', 11.73504696), ('Solomon Islands', 11.52643094), ('Somalia', 13.60078323), ('South Africa', 12.68336805), ('South Asia', 14.15399379), ('South Korea', 12.51254632), ('South Sudan', 12.84915342), ('Southeast Asia', 11.178779800000001), ('Southeast Asia, East Asia, and Oceania', 11.36334388), ('Southern Latin America', 17.69665441), ('Southern Sub-Saharan Africa', 12.30918393), ('Spain', 17.792976), ('Sri Lanka', 11.77984105), ('Sub-Saharan Africa', 12.38014173), ('Sudan', 16.20578193), ('Suriname', 14.69441162), ('Swaziland', 11.98993742), ('Sweden', 17.07029802), ('Switzerland', 16.11462988), ('Syria', 15.14917245), ('Taiwan', 11.34479631), ('Tajikistan', 10.66765035), ('Tanzania', 12.84531097), ('Thailand', 11.58945392), ('Timor', 12.18815113), ('Togo', 11.64713921), ('Tonga', 11.127248300000002), ('Trinidad and Tobago', 14.13853862), ('Tropical Latin America', 15.87255877), ('Tunisia', 15.46389664), ('Turkey', 14.37781722), ('Turkmenistan', 10.60730075), ('Uganda', 13.83576608), ('Ukraine', 12.00245733), ('United Arab Emirates', 12.9810669), ('United Kingdom', 15.21600677), ('United States', 18.321319100000004), ('United States Virgin Islands', 13.90457778), ('Uruguay', 17.52487641), ('Uzbekistan', 10.63014456), ('Vanuatu', 11.326688800000001), ('Venezuela', 11.00208908), ('Vietnam', 10.35949716), ('Wales', 15.22774474), ('Western Europe', 16.67451088), ('Western Sub-Saharan Africa', 11.84614427), ('World', 13.25913163), ('Yemen', 16.26715494), ('Zambia', 12.48545528), ('Zimbabwe', 10.72870234)]
[('Afghanistan', 16.96302255), ('Albania', 11.04317255), ('Algeria', 15.01159706), ('American Samoa', 11.00426893), ('Andean Latin America', 12.78711135), ('Andorra', 15.86184049), ('Angola', 12.32294585), ('Antigua and Barbuda', 13.39239094), ('Argentina', 17.59874775), ('Armenia', 10.57489953), ('Australasia', 19.35432947), ('Australia', 19.21619405), ('Austria', 15.60071603), ('Azerbaijan', 10.41648516), ('Bahamas', 13.49120068), ('Bahrain', 14.81627383), ('Bangladesh', 13.28903163), ('Barbados', 13.6026348), ('Belarus', 12.08195744), ('Belgium', 15.65338106), ('Belize', 13.47286976), ('Benin', 11.693028199999999), ('Bermuda', 13.90287959), ('Bhutan', 12.24140941), ('Bolivia', 13.31196751), ('Bosnia and Herzegovina', 11.09141289), ('Botswana', 12.12793237), ('Brazil', 15.79262155), ('Brunei', 11.74390488), ('Bulgaria', 11.37402183), ('Burkina Faso', 11.69866487), ('Burundi', 13.31775657), ('Cambodia', 11.86483359), ('Cameroon', 11.75166617), ('Canada', 15.67775188), ('Cape Verde', 11.94527944), ('Caribbean', 13.83525884), ('Central African Republic', 12.52543399), ('Central Asia', 10.74032131), ('Central Europe', 11.07793467), ('Central Europe, Eastern Europe, and Central Asia', 11.35330022), ('Central Latin America', 10.87214112), ('Central Sub-Saharan Africa', 12.334849499999999), ('Chad', 12.13279508), ('Chile', 18.03206451), ('China', 11.349312699999999), ('Colombia', 9.632960357), ('Comoros', 12.69160245), ('Congo', 12.24803579), ('Costa Rica', 11.063826400000002), ("Cote d'Ivoire", 11.36639947), ('Croatia', 11.47753656), ('Cuba', 14.17651035), ('Cyprus', 15.31440481), ('Czech Republic', 11.35739402), ('Democratic Republic of Congo', 12.338106100000001), ('Denmark', 15.22011944), ('Djibouti', 12.93323532), ('Dominica', 13.36071525), ('Dominican Republic', 13.77695698), ('East Asia', 11.35417594), ('Eastern Europe', 11.77542009), ('Eastern Sub-Saharan Africa', 13.03665488), ('Ecuador', 13.17278014), ('Egypt', 14.85395534), ('El Salvador', 11.16447313), ('England', 15.11067396), ('Equatorial Guinea', 12.39682448), ('Eritrea', 13.15261887), ('Estonia', 12.09143264), ('Ethiopia', 13.13708633), ('Fiji', 11.26542022), ('Finland', 15.17243141), ('France', 18.31508867), ('Gabon', 12.11815789), ('Gambia', 12.89069875), ('Georgia', 10.62417976), ('Germany', 17.10398727), ('Ghana', 11.26053647), ('Greece', 16.94804923), ('Greenland', 18.84740954), ('Grenada', 13.39492198), ('Guam', 11.38931274), ('Guatemala', 11.38034381), ('Guinea', 11.66951167), ('Guinea-Bissau', 11.74603891), ('Guyana', 14.81224657), ('Haiti', 13.66708124), ('High SDI', 15.76582463), ('High-income', 16.58878473), ('High-income Asia Pacific', 12.26919107), ('High-middle SDI', 12.92406777), ('Honduras', 10.84039681), ('Hungary', 11.49333065), ('Iceland', 15.32941138), ('India', 14.57455363), ('Indonesia', 11.0848362), ('Iran', 18.37477299), ('Iraq', 14.88806445), ('Ireland', 16.71311162), ('Israel', 13.06232688), ('Italy', 16.03737831), ('Jamaica', 13.37008289), ('Japan', 12.12948742), ('Jordan', 14.80317577), ('Kazakhstan', 11.12340044), ('Kenya', 12.65522997), ('Kiribati', 11.34281384), ('Kuwait', 14.84669463), ('Kyrgyzstan', 10.90026083), ('Laos', 12.38845661), ('Latin America and Caribbean', 13.20807069), ('Latvia', 11.46447251), ('Lebanon', 16.69713438), ('Lesotho', 13.88127814), ('Liberia', 12.71138902), ('Libya', 15.01543172), ('Lithuania', 12.15796108), ('Low SDI', 13.71076578), ('Low-middle SDI', 13.51480553), ('Luxembourg', 15.83891198), ('Macedonia', 11.14472764), ('Madagascar', 12.955444199999999), ('Malawi', 12.62239116), ('Malaysia', 12.86586099), ('Maldives', 11.6660741), ('Mali', 11.13135319), ('Malta', 15.44068507), ('Marshall Islands', 11.26795078), ('Mauritania', 11.02407465), ('Mauritius', 11.77589263), ('Mexico', 11.27734572), ('Micronesia (country)', 11.27620695), ('Middle SDI', 12.05362494), ('Moldova', 11.47204216), ('Mongolia', 11.10974161), ('Montenegro', 11.36457134), ('Morocco', 16.83955197), ('Mozambique', 13.03402798), ('Myanmar', 10.75678611), ('Namibia', 11.47981766), ('Nepal', 13.00299634), ('Netherlands', 17.39198137), ('New Zealand', 20.07796042), ('Nicaragua', 11.00770166), ('Niger', 11.98280649), ('Nigeria', 12.03532903), ('North Africa and Middle East', 15.76453694), ('North America', 18.0854826), ('North Korea', 11.63719877), ('Northern Ireland', 18.45449437), ('Northern Mariana Islands', 11.00313247), ('Norway', 17.44120257), ('Oceania', 11.42883974), ('Oman', 14.48148729), ('Pakistan', 12.428950500000001), ('Palestine', 16.09246773), ('Panama', 10.84318046), ('Papua New Guinea', 11.46752376), ('Paraguay', 15.41172376), ('Peru', 12.42968215), ('Philippines', 11.21610424), ('Poland', 10.82358254), ('Portugal', 16.54852173), ('Puerto Rico', 13.50608769), ('Qatar', 14.70538057), ('Romania', 10.80038069), ('Russia', 11.68737421), ('Rwanda', 13.206261600000001), ('Saint Lucia', 13.51260182), ('Saint Vincent and the Grenadines', 13.38006202), ('Samoa', 11.08998763), ('Sao Tome and Principe', 11.2637118), ('Saudi Arabia', 14.32870148), ('Scotland', 15.09166848), ('Senegal', 11.24629095), ('Serbia', 11.30709206), ('Seychelles', 11.073687300000001), ('Sierra Leone', 11.79165668), ('Singapore', 12.81709577), ('Slovakia', 11.1766752), ('Slovenia', 11.73401618), ('Solomon Islands', 11.50176167), ('Somalia', 13.43980578), ('South Africa', 12.69554577), ('South Asia', 14.14478189), ('South Korea', 12.55000474), ('South Sudan', 12.86651345), ('Southeast Asia', 11.16085472), ('Southeast Asia, East Asia, and Oceania', 11.3252282), ('Southern Latin America', 17.71580083), ('Southern Sub-Saharan Africa', 12.31743926), ('Spain', 17.80454817), ('Sri Lanka', 11.74478956), ('Sub-Saharan Africa', 12.3589356), ('Sudan', 16.21379206), ('Suriname', 14.68237175), ('Swaziland', 12.000217999999998), ('Sweden', 17.05990517), ('Switzerland', 16.11898788), ('Syria', 15.1725894), ('Taiwan', 11.3388338), ('Tajikistan', 10.65909441), ('Tanzania', 12.85777367), ('Thailand', 11.57832474), ('Timor', 12.16446983), ('Togo', 11.64411736), ('Tonga', 11.12070429), ('Trinidad and Tobago', 14.13376015), ('Tropical Latin America', 15.78062659), ('Tunisia', 15.46527405), ('Turkey', 14.35562438), ('Turkmenistan', 10.6132007), ('Uganda', 13.79020212), ('Ukraine', 11.99350866), ('United Arab Emirates', 12.97799316), ('United Kingdom', 15.21645503), ('United States', 18.34744604), ('United States Virgin Islands', 13.89217659), ('Uruguay', 17.55746782), ('Uzbekistan', 10.62503286), ('Vanuatu', 11.31835322), ('Venezuela', 11.00337382), ('Vietnam', 10.34682823), ('Wales', 15.24882039), ('Western Europe', 16.66972185), ('Western Sub-Saharan Africa', 11.80222319), ('World', 13.24572917), ('Yemen', 16.29606734), ('Zambia', 12.52886108), ('Zimbabwe', 10.74069569)]
import pandas as pd
import numpy as np
from pyecharts.charts import Geo
from pyecharts import options as opts
from pyecharts.globals import ChartType, SymbolType,ThemeType
from pyecharts.charts import Bar,Tab,Line,Map,Timeline
def timeline_map() -> Timeline:
tl = Timeline()
for i in range(2014,2018):
map0 = (
Map()
.add(
"女性患病率",list(zip(list(df.Country),list(df["{}年".format(i)]))),"world",is_map_symbol_show = False
)
.set_global_opts(
title_opts=opts.TitleOpts(title="{}年女性患病率".format(i),subtitle="",
subtitle_textstyle_opts=opts.TextStyleOpts(color="red",font_size=18,font_style="italic")),
visualmap_opts=opts.VisualMapOpts(min_= 10,max_=20)
)
)
tl.add(map0,"{}年".format(i))
return tl
timeline_map().render_notebook()
import plotly as py
py.offline.init_notebook_mode()
import pandas as pd
df = pd.read_csv('data_1.csv',encoding='gbk')
df.head(2)
| 指标 | 2007年 | 2008年 | 2009年 | 2010年 | 2011年 | 2012年 | 2013年 | 2014年 | 2015年 | 2016年 | 2017年 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CHNmales | 11.420509 | 11.438862 | 11.452765 | 11.454783 | 11.447784 | 11.438664 | 11.426793 | 11.412147 | 11.394749 | 11.374748 | 11.352498 |
| 1 | CHNfemales | 11.632663 | 11.632112 | 11.628203 | 11.611661 | 11.585647 | 11.556362 | 11.522448 | 11.484265 | 11.441721 | 11.397336 | 11.349313 |
list(df.iloc[0])[1:]
[11.420508900000002, 11.438862400000001, 11.45276503, 11.45478285, 11.44778355, 11.43866391, 11.42679288, 11.41214671, 11.39474934, 11.37474847, 11.35249761]
list(df.iloc[1])[1:]
[11.63266274, 11.63211239, 11.62820258, 11.61166116, 11.58564658, 11.55636216, 11.52244813, 11.48426535, 11.44172054, 11.39733557, 11.349312699999999]
list(df.set_index('指标').columns)
['2007年', '2008年', '2009年', '2010年', '2011年', '2012年', '2013年', '2014年', '2015年', '2016年', '2017年']
for i in range(2007,2017):
print(list(zip(list(df.指标),list(df["{}年".format(i)]))))
[('CHNmales', 11.420508900000002), ('CHNfemales', 11.63266274), ('USmales', 16.49849931), ('USfemales', 18.50814858)]
[('CHNmales', 11.438862400000001), ('CHNfemales', 11.63211239), ('USmales', 16.42848063), ('USfemales', 18.42452656)]
[('CHNmales', 11.45276503), ('CHNfemales', 11.62820258), ('USmales', 16.36642072), ('USfemales', 18.34763062)]
[('CHNmales', 11.45478285), ('CHNfemales', 11.61166116), ('USmales', 16.33290129), ('USfemales', 18.30838166)]
[('CHNmales', 11.44778355), ('CHNfemales', 11.58564658), ('USmales', 16.32155897), ('USfemales', 18.29714292)]
[('CHNmales', 11.43866391), ('CHNfemales', 11.55636216), ('USmales', 16.30975748), ('USfemales', 18.28951618)]
[('CHNmales', 11.42679288), ('CHNfemales', 11.52244813), ('USmales', 16.29818911), ('USfemales', 18.28964709)]
[('CHNmales', 11.41214671), ('CHNfemales', 11.48426535), ('USmales', 16.28818571), ('USfemales', 18.29373474)]
[('CHNmales', 11.39474934), ('CHNfemales', 11.44172054), ('USmales', 16.27814981), ('USfemales', 18.30431071)]
[('CHNmales', 11.37474847), ('CHNfemales', 11.39733557), ('USmales', 16.27053323), ('USfemales', 18.321319100000004)]
from pyecharts.faker import Faker
from pyecharts import options as opts
from pyecharts.charts import Bar, Page, Pie, Timeline
def timeline_bar() -> Timeline:
x = list(df.set_index('指标').columns)
tl = Timeline()
for i in range(2007, 2017):
bar = (
Bar()
.add_xaxis(x)
.add_yaxis("男性", list(df.iloc[0])[1:])
.add_yaxis("女性", list(df.iloc[1])[1:])
.set_global_opts(title_opts=opts.TitleOpts("中国男女性心理健康障碍患病率".format(i)))
)
tl.add(bar, "{}年".format(i))
return tl
tl = timeline_bar()
tl.render_notebook()
import pandas as pd
df = pd.read_csv("data_1.csv",encoding='ANSI')
df.head(4)
| 指标 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CHNmales | 11.420509 | 11.438862 | 11.452765 | 11.454783 | 11.447784 | 11.438664 | 11.426793 | 11.412147 | 11.394749 | 11.374748 | 11.352498 |
| 1 | CHNfemales | 11.632663 | 11.632112 | 11.628203 | 11.611661 | 11.585647 | 11.556362 | 11.522448 | 11.484265 | 11.441721 | 11.397336 | 11.349313 |
| 2 | USmales | 16.498499 | 16.428481 | 16.366421 | 16.332901 | 16.321559 | 16.309757 | 16.298189 | 16.288186 | 16.278150 | 16.270533 | 16.263874 |
| 3 | USfemales | 18.508149 | 18.424527 | 18.347631 | 18.308382 | 18.297143 | 18.289516 | 18.289647 | 18.293735 | 18.304311 | 18.321319 | 18.347446 |
list(df.iloc[0])[1:]
[11.420508900000002, 11.438862400000001, 11.45276503, 11.45478285, 11.44778355, 11.43866391, 11.42679288, 11.41214671, 11.39474934, 11.37474847, 11.35249761]
list(df.iloc[1])[1:]
[11.63266274, 11.63211239, 11.62820258, 11.61166116, 11.58564658, 11.55636216, 11.52244813, 11.48426535, 11.44172054, 11.39733557, 11.349312699999999]
list(df.iloc[2])[1:]
[16.49849931, 16.42848063, 16.36642072, 16.33290129, 16.32155897, 16.30975748, 16.29818911, 16.28818571, 16.27814981, 16.27053323, 16.26387429]
list(df.iloc[3])[1:]
[18.50814858, 18.42452656, 18.34763062, 18.30838166, 18.29714292, 18.28951618, 18.28964709, 18.29373474, 18.30431071, 18.321319100000004, 18.34744604]
list(df.set_index('指标').columns)
['2007', '2008', '2009', '2010', '2011', '2012', '2013', '2014', '2015', '2016', '2017']
from pyecharts import options as opts
from pyecharts.charts import Bar, Grid, Line,Scatter
def grid_vertical() -> Grid:
bar = (
Bar()
.add_xaxis(list(df.set_index('指标').columns))
.add_yaxis("中国男性", list(df.iloc[0])[1:])
.add_yaxis("中国女性", list(df.iloc[1])[1:])
.add_yaxis("美国男性", list(df.iloc[2])[1:])
.add_yaxis("美国女性", list(df.iloc[3])[1:])
.set_global_opts(title_opts=opts.TitleOpts(title="对比图1"))
)
line = (
Line()
.add_xaxis(list(df.set_index('指标').columns))
.add_yaxis("中国男性", list(df.iloc[0])[1:])
.add_yaxis("中国女性", list(df.iloc[1])[1:])
.add_yaxis("美国男性", list(df.iloc[2])[1:])
.add_yaxis("美国女性", list(df.iloc[3])[1:])
.set_global_opts(
title_opts=opts.TitleOpts(title="对比图2", pos_top="60%"),
legend_opts=opts.LegendOpts(pos_top="60%"),
)
)
grid = (
Grid()
.add(bar, grid_opts=opts.GridOpts(pos_bottom="60%"))
.add(line, grid_opts=opts.GridOpts(pos_top="60%"))
)
return grid
grid_vertical().render_notebook()